Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “hirelings” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

131 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
hirelings136576(None) 
hireling121210991hireling_
birlings11359612bir_lings
heelings12359752h_eelings
hirpling1467222hirpling_
hirseling1396272hirseling_
hirsling1277542hirsling_
hurlings12388212hur_lings
shielings13237122shi_elings
airings83913843air__ings
airlines8312793air_lines
athelings1345113athelings
billings113412633bi_llings
birdings12378823bir_dings
birling104317053bir_ling_
birthings15254623birthings
bitewings1542943bitewings
brewings14296693_brewings
briefings1543733briefings
brislings12236363brislings
cagelings1335413cagelings
carlings114015853car_lings
chiseling1536403chiseling_
chitlings15255903chi_tlings
circling1338423circling_
corbelings1544073corbelings
curlings114110383cur_lings
darklings1533983darklings
darlings103710383dar_lings
dialings10329823di_alings
diallings1134993diallings
dieselings1252933dieselings
dirling93316073dir_ling_
drillings11285823drillings
feelings12338933_feelings
filings115213073fi__lings
fillings122910503fi_llings
firefangs1643053firefangs
firepinks1852823firepinks
firings114112333fir__ings
firstlings1442523firstlings
forewings1645113forewings
frillings13265803frillings
girdling1146823girdling_
gruelings1163763gruelings
hairlines1237133hair_lines
handlings14237343handlings
hardenings1544243hardenings
harelips1345213hareli_ps
harpings14379773har_pings
heeling113618513h_eeling_
helpings14255653h__elpings
herrings12379533her_rings
hidings12349703hi__dings
hieing104216623hi_e_ing_
higgling14217163higgling_
hildings13347503hi_ldings
hilling113821773hi_lling_
hiplines13310593hi_plines
hiring104421603hir__ing_
hirselling1444833hirselling_
hirudins1244933hirudin_s
hissings12556753hi_ssings
hornings12238363hor_nings
hoveling15189593hoveling_
hurdling13288013hurdling_
hurling113616413hur_ling_
hurtling12318313hurtling_
inklings13246383_inklings
ironings9217583_ironings
killings133710483ki_llings
kindlings15195273kindlings
kitlings13318103ki_tlings
libeling1139873libeling_
lifelines12147053lifelines
lordlings1143923lordlings
marblings14225543marblings
marlings113713493mar_lings
middlings14194313middlings
millings113712583mi_llings
modelings1335563modelings
niderings1175403niderings
nigglings12213733nigglings
nurslings1043733nurslings
panelings12107453panelings
peelings11339523_peelings
piecings1345343pi_ecings
piercings1453263piercings
pilings103313613pi__lings
pipelines13178353pipelines
purflings1554093purflings
purlings113910283pur_lings
ravelings13377383ravelings
reelings94012563_reelings
relines75331323__relines
relinks114510223__relinks
ridgelings13172993ridgelings
ridglings12214183ridglings
rieslings1034493rieslings
riflings12227303ri_flings
rulings83310383__rulings
shavelings1743503shavelings
shieling123512403shi_eling_
shillings13348093shi_llings
shirrings13245323shir_rings
shirtings13276603shir_tings
shorelines1346143shorelines
siblings11108123si_blings
sidelines10109683sidelines
sideling101012183sideling_
sterlings10308753sterlings
thirling12248583thir_ling_
tilings84212793ti__lings
timelines1148443timelines
tinklings14224663tinklings
tirling83315733tir_ling_
towelings13234693towelings
triflings13235973triflings
turtlings10184873turtlings
viewings1533983vi_ewings
wheelings16284933wheelings
whirling15237163whir_ling_
whistlings1742913whistlings
whitenings1742613whitenings
whitewings2042333whitewings
whittlings1742223whittlings
wildlings14244923wildlings
windlings14236723windlings
wirings113910113wir__ings
witlings12328443wi_tlings
zibelines2045733zibelines

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.423422437.4
2DLD Change Limit1486411316.64022385.7
3Display Results1311310.0632079.4
 (SQL Overall)1786911317.12625075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.