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

123 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
taxies13581733(None) 
ataxies142410011ataxies
taxes124730821tax_es
taxied14509371taxied
taxis126821971taxi_s
taxites1449671taxites
amies76837692_amies
ataxias14189342ataxias
ataxics16196642ataxics
axes117337852_ax_es
axils127217502_axils
axis116127912_axi_s
axises134413992_axises
axites134913832_axites
axles125219472_axles
babies106123652babies
braxies16711462braxies
caries85147622caries
cavies114525002cavies
davies105020512davies
dexies145018342dexies
doxies143917852doxies
easies64126632easies
eutaxies1545792eutaxies
facies113921592facies
faxes155726652fax_es
gabies93820732gabies
ladies75124882ladies
laxes125430092lax_es
lazies154418782lazies
mamies104626242mamies
mavies114923192mavies
maxes145629532max_es
maxims17399672maxims
maxis145721562maxi_s
maxixes1535252maxixes
moxies154317402moxies
navies95218622navies
nixies135313872nixies
paries84742512paries
paxes144928422pax_es
pixies154915512pixies
pyxies18338292pyxies
rabies85226022rabies
ramies84630462ramies
raxes124729392rax_es
sanies63031952sanies
saxes125229342sax_es
tabbies112913502tabbies
tabes76033922ta_bes
tables84524892tables
taces76237802ta_ces
taches114224172taches
taffies133012692taffies
tafias93111962tafias
tails55634192ta_ils
tains54936322ta_ins
tajes124920692ta_jes
takes94437792ta_kes
takins105117402takins
tales55451372ta_les
talipes9611602talipes
talkies113415732talkies
tallies73624602tallies
tames75242012ta_mes
tamis76728732tami_s
tamises92715972tamises
tammies113814682tammies
tansies74521242tansies
tapes75838602ta_pes
tapirs84113172tapirs
tapis75028862tapi_s
tapises92914012tapises
tardies84225862tardies
tares57456562ta_res
targes74524592targes
tarres64723042tarres
tarries73324262tarries
tasses64826762tasses
tassies74918932tassies
tastes64126422tastes
tates55444982ta_tes
tatties74120342tatties
taupes8212672taupes
tawie84819812tawie_
tawnies102812502tawnies
tawpies12309872tawpies
tawses94913192tawses
taxed135620292tax_ed
taxemes1635852taxemes
taxer125019362tax_er
taxers134015282taxers
taxi117124762taxi__
taximen1644922taximen
taxing143816712taxing
taxite13511302taxite
taxless1436912taxless
taxmen15367442taxmen
taxols13328632taxols
taxons134211502taxons
taxus125512482tax_us
taxwise1734252taxwise
tidies74721832tidies
ties45248312t__ies
toadies82914862toadies
tobies84521022tobies
todies74223552todies
tories65435882tories
towies93521192towies
toxics153910202toxics
toxines142912262toxines
toxins133314282toxins
tries55742812t_ries
tuxes124316042tux_es
varies94330872varies
wadies105121202wadies
walies95324522walies
wavies125019842wavies
waxes155825502wax_es
waxier16439902waxier
waxiest173510882waxiest
zanies153219672zanies
zaxes215113822zax_es

Search took 3 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 Filter178691825510.1061685764.2
2DLD Change Limit825511232.29635954.3
3Display Results1231230.0333727.3
 (SQL Overall)1786911232.43573384.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.