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 “guiling” with Change Limit: [1] [2]

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

107 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
guiling9321421(None) 
guiding102911841guiding
guising93511411guising
gulling94019561gulling
ailing74331012_ailing
bailing103723522bailing
beguiling1334852beguiling
boiling103819672boiling
bugling113615342bugling
building1237502building
bulling104324792bulling
burling104421132burling
butling103516812butling
ceiling103416722ceiling
coiling103723452coiling
culling103921302culling
curling104320182curling
dueling93614542dueling
dulling93418272dulling
exiling15311082exiling
failing113521332failing
filing103823762_filing
foiling113317652foiling
fueling113615132fueling
fugling124212512fugling
fulling114019702fulling
furling114016562furling
gabling113514542gabling
gaining94015662gaining
gaiting93716582gaiting
galling93921962galling
gaoling93314652gaoling
gelling93219762gelling
gibing103712352g_ibing
gieing83614852g_ieing
gilding103813002g_ilding
gilling93520382gilling
giving114313882g_iving
gliding103911842gliding
gliming113310132gliming
goaling93515332goaling
godling103513402godling
gosling93312402gosling
griding103014972griding
grilling103811532grilling
griming113612492griming
griping113012062griping
grueling1078272grueling
guggling10236352guggling
gulfing12339472gulfing
gullwing13304922gullwing
gullying13367242gullying
gulping11309752gulping
gumline102810112gumline
gumming133810192gumming
gunning93413172gunning
gurging102910112gurging
gurgling11267322gurgling
gushing124014222gushing
gusting93917162gusting
gutting93415922gutting
guttling1037292guttling
guying11379722gu_ying
guyline11258172guyline
guzzling18225062guzzling
hailing113820692hailing
heiling113616362heiling
hulling113619012hulling
hurling113616412hurling
jailing153415842jailing
juicing1736882juicing
lulling83616802lulling
mailing102923342mailing
moiling103417662moiling
muling93519882mu_ling
mulling103819992mulling
nailing83419962nailing
nulling83818062nulling
nurling84215822nurling
oiling74925312_oiling
piling95025592_piling
puling93621402pu_ling
pulling103821072pulling
purling103620292purling
quailing1838402quailing
quilling182510002quilling
quilting18218712quilting
quiring17159992quiring
quisling18218062quisling
railing83325642railing
riling74227972_riling
roiling83220452roiling
ruining83514882ruining
ruling73219552ru_ling
sailing83927372sailing
smiling103915442smiling
soiling83422322soiling
spiling102919702spiling
suiting83419002suiting
tailing82923102tailing
tiling73426552_tiling
toiling83219022toiling
vailing113817952vailing
veiling113615292veiling
wailing113620902wailing
whiling143511742whiling
wiling103024292_wiling

Search took 4 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 Filter1786911076710.470380193.6
2DLD Change Limit1076711073.36032044.9
3Display Results1071070.0303566.7
 (SQL Overall)1786911073.86046293.0
 
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.