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

106 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
outgaining123709(None) 
obtaining1236772obt_aining
outearning1146742outearning
outfawning1744222outfawning
outgassing1245352outgassing
outgazing2037142outga_zing
outgiving1436212outg_iving
outgrinning1353692outgrinning
outguiding1344732outguiding
outgunning1244242outgunning
outlining10310502out_lining
outmanning1345542outmanning
outpainting1445152outpainting
outraising1139902outraising
outsailing1137562outsailing
outshining1446532outshining
outwaiting1446732outwaiting
attaining1047223_attaining
bargaining1445213bargaining
containing13410933cont_aining
curtaining1345533curtaining
detaining112510473det_aining
detraining1267673detraining
entraining1147643entraining
fountaining15103643fountaining
gaining94015663___gaining
mutining11310493mut__ining
ordaining1145753o_rdaining
outacting1239213out_acting
outadding1235793out_adding
outasking1437313out_asking
outbaking1638233outba_king
outbargaining176823outbargaining
outbarking1746213outbarking
outbawling1644933outbawling
outbribing1545573outbribing
outburning1345093outburning
outcaviling1742983outcaviling
outchiding1745183outchiding
outdancing1445223outdancing
outdaring1179723outda_ring
outdating11810863outda_ting
outdrinking1743963outdrinking
outdriving1545583outdriving
outeating10814493outea_ting
outfabling1644543outfabling
outfacing1578113outfa_cing
outfasting1446333outfasting
outfinding1545873out_finding
outfiring1338163out_firing
outgain81010743outga__in_
outgained1137223outgain_ed
outgains9810163outga__ins
outgambling1742133outgambling
outgivings1542333outg_ivings
outglaring1246273outglaring
outglowing1544683outglowing
outgnawing1544433outgnawing
outgoing1039273outg__oing
outgrowing1555643outgrowing
outgushing1544573outgushing
outjinxing2543963out_jinxing
outlasting1137523outlasting
outlawing1337933outla_wing
outlaying1338543outla_ying
outlearning1243543outlearning
outliving1337793out_living
outpacing1478363outpa_cing
outpassing1355853outpassing
outplanning1463833outplanning
outpointing1445103outpointing
outpricing1547003outpricing
outracing12912163outra_cing
outraging111010883outra_ging
outranging1238003outranging
outranking1537673outranking
outrating10916403outra_ting
outraving13910133outra_ving
outriding11310623out_riding
outringing1247813out_ringing
outrunning1145683outrunning
outsaying1338703outsa_ying
outsinging1246273out_singing
outsinning1146173outsinning
outsmiling1345743outsmiling
outspanning1443563outspanning
outswinging1643433outswinging
outtalking1545483outtalking
outtasking1545723outtasking
outthinking1943653outthinking
outvaluing1444223outvaluing
outvaunting1542893outvaunting
outvoicing1644763outvoicing
outwalking1845283outwalking
outwarring1445363outwarring
outwasting1446433outwasting
outwiling1337463out_wiling
outwinding1545653out_winding
outwriting1447183outwriting
regaining112411083_regaining
retaining102114733ret_aining
retraining11310243retraining
staining9413373_st_aining
straining10410563_straining
sustaining1145883sustaining
training93015863__training

Search took 7 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 Filter1786911406030.420425454.8
2DLD Change Limit1406031065.62624991.6
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.09229332.1
 
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.