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

140 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
thanes9491898(None) 
ethanes103713511ethanes
thane86122531thane_
thanks134313131thanks
anes45255932__anes
banes74945582_banes
bhangs12449662bhangs
canes75350372_canes
chafes145017912chafes
chaines124518732chaines
chances145218092chances
changes134517582changes
changs125215372changs
chants115020392chants
chapes135421872chapes
chares115631802chares
chases115128232chases
chines115029172chines
cranes84330752cranes
ethane94613242ethane_
ethenes103313872ethenes
ethynes13377572ethynes
fanes84639892_fanes
flanes94522422flanes
hades96035112_hades
haes77651022_ha_es
hajes155420942_hajes
hakes126034302_hakes
hales85449842_hales
hames106138702_hames
hances115621282_hances
hands95327382_hands
hangs95726722_hangs
hanks126226862_hanks
hanse85722792_hanse
hanses95022632_hanses
hants86335402_hants
hares86255542_hares
hates86742572_hates
haves116034872_haves
hazes174928322_hazes
hones88144492_hones
inanes62519802inanes
janes124928122_janes
kanes95529372_kanes
khans124615172khan_s
lanes54946792_lanes
lianes63819322lianes
manes76648952_manes
methanes133812162methanes
panes76148692_panes
phages125213512phages
phases114618402phases
phones114121212phones
planes85028082planes
sanes55649072_sanes
shades105924532shades
shakes135024592shakes
shales94731252shales
shames114726222shames
shanks135315582shanks
shapes115124942shapes
shares95236412shares
shaves125224932shaves
shines95028912shines
stanes64933402stanes
tabes76033922t_abes
taces76237802t_aces
tajes124920692t_ajes
takes94437792t_akes
tales55451372t_ales
tames75242012t_ames
tangs65028342t_angs
tanks94624732t_anks
tans46154812t_an_s
tapes75838602t_apes
tares57456562t_ares
tates55444982t_ates
taxes124730822t_axes
teases65426272teases
ternes65422902ternes
thacks154311922thacks
thae76825562tha_e_
thaler94613102thaler
thalers106212262thalers
than76128772than__
thanages12107612thanages
thank125817802than_k
thanked15469152thanked
thanker14309592thanker
thankers15297832thankers
tharms115712242tharms
thawed13458462thawed
thawer12489342thawer
thawers13428482thawers
thaws116515462tha_ws
thebes115914492thebes
theines104013232theines
themes115319252themes
thens85921832then_s
theres96525472theres
theses96517972theses
thine85026852thine_
things104914282things
thinks134613352thinks
thins85826322thin_s
tholes94919782tholes
thongs104611182thongs
thraves13469712thraves
threes97117322threes
throes97518672throes
thrones105715842thrones
thunks13459032thunks
thymes144810742thymes
tines54848422t_ines
tisanes7311852tisanes
tolanes74216312tolanes
tones56048662t_ones
tonnes65320852tonnes
traces85329932traces
trades75724492trades
trances93919642trances
tranks104017762tranks
tranqs155210312tranqs
trans54933042tran_s
trapes85024462trapes
traves94222742traves
trines64132562trines
trones65629282trones
tsades74310992tsades
tunes55332192t_unes
twaes86513662twa_es
twangs10358092twangs
twines94717272twines
tynes85920302t_ynes
vanes85130972_vanes
wanes85040882_wanes
whales124716942whales
whangs13439722whangs
whines125120102whines

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.1261418182.5
2DLD Change Limit825511402.68630733.8
3Display Results1401400.0931505.4
 (SQL Overall)1786911402.90561511.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.