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 “gingall” 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.

129 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
gingall911733(None) 
gingal81010151ginga_l
gingalls1096431gingalls
gingals9109311gingals
jingall1566171jingall
gingeli9286152gingeli
gingelli10304392gingelli
gingelly13305692gingelly
gingely12378212gingely
gingili9306032gingili
gingilli10274412gingilli
infall939402_infall
inwall938342_inwall
jingal1498592jinga_l
jingalls1685332jingalls
jingals1588072jingals
pinball1137932pinball
windgall1343852windgall
ainsell796393ainsell
begall92610723_begall
binal75323823bin_a_l
cingula10327173cingula
dingily1238103dingily
dingle84317073ding_le
finagle11238313finagle
final83922033fin_a_l
finale94116763fin_ale
finally13310103fin_ally
finals94316163fin_als
finial92814183finia_l
finials103210153finials
fungal10388733funga_l
fungals11276783fungals
gadwall1244563gadwall
galingale1143133galingale
gall56335993___gall
gangly113911583gang_ly
gangrel996143gangrel
genial74917613genia_l
genially12129523genially
giga66720943gi_ga__
gigas75415583gi_ga_s
giggle94313513gi_ggle
giggly12518703gi_ggly
gigolo836533gi_golo
gildhall1342023gildhall
gill56336183gi___ll
gimbal11228813gimba_l
gimbals12257823gimbals
gimmal11247513gimma_l
gimmals12225823gimmals
gingeley13294673gingeley
gingelis10247093gingelis
gingellis11244203gingellis
ginger84920033ging_er
gingerly13315303gingerly
gingers94118643gingers
gingery12368913gingery
gingham1484453gingham
ginghams1573893ginghams
gingilis10255593gingilis
gingillis11213743gingillis
gingiva1253293gingiva
gingival1342943gingival
gingko12376033ging_ko
gingkos13405343gingkos
gnarl65115573g_n_arl
gringa838553gringa__
gringas938043gringa_s
gumball1266833gumball
gunwale1134733gunwale
infalls1038943_infalls
infill938413_infill
ingate73018243_ingate
ingle64120433_ing_le
ingulf10310353_ingulf
inhale9411513_inhale
inhaul936803_inhaul
install779363_install
inwalls1037283_inwalls
jingle143815223jing_le
jingly174111933jing_ly
kingly143511303king_ly
linalol745093lin_alol
lineal65616023linea_l
lineally1137793lineally
linga66820823linga__
lingam95112353linga_m
lingams104510193lingams
lingas75116573linga_s
lingual8379083lingual
lingually1344373lingually
linguals9317223linguals
lingula8428803lingula
mingle93518783ming_le
miscall1139643miscall
nutgall844443nutgall
pinballs1246933pinballs
pineal84817683pinea_l
pineals93212843pineals
pinnal84814273pinna_l
pintail9311183pintail
pinwale1257843pinwale
pitfall1245823pitfall
rainfall1144473rainfall
ringhals1256263ringhals
ringtail944723ringtail
signal73711483signa_l
signally1246533signally
signals8359163signals
singable11159543singable
single74520603sing_le
singly104015853sing_ly
tincal83913363tinca_l
tincals93610643tincals
tineal66216163tinea_l
tingle74319063ting_le
tingly103815973ting_ly
vinal85725813vin_a_l
vinals94716483vin_als
vineal94814743vinea_l
windfall1544203windfall
windgalls1443133windgalls
zingani1744813zingani
zingano1744203zingano
zingara1745513zingara
zingare1737143zingare
zingari1745483zingari
zingaro1745123zingaro

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271296.78319759.3
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.23224708.4
 
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.