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

119 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
fetus8581654(None) 
fetas85624401fetas
fetes85630141fetes
fets75345941fet_s
feus75830751fe_us
foetus958521foetus
beaus75127112beaus
betas75528762betas
beths105519222beths
bets67051442bet_s
cestus84412912cestus
cetes75731102cetes
ecus65421462_ecus
efts76519482eft_s
emus66821682_emus
etas46432272_etas
eths76619522_eths
etui45416232_etui
etuis54013132_etuis
fates85139232fates
fats76252502fat_s
favus114311732favus
fears84829392fears
feats86432752feats
feces105625362feces
fecks145417852fecks
feds85234312fe_ds
feebs106112682feebs
feeds94921142feeds
feels85223042feels
fees76450602fe_es
fehs106522382fe_hs
fells85327382fells
felts85324542felts
femes105626222femes
fems96428702fe_ms
femur1038682femur
femurs1136712femurs
fends96324972fends
fens76139762fe_ns
feods99516852feods
feres86038182feres
ferns85220082ferns
fes66551672fe__s
fess76529162fe_ss
fests85828042fests
fet66471632fet__
feta76528902fet_a
fetal85623372fetal
fetch134913472fetch
fete75734922fet_e
feted94420932feted
fetid93715982fetid
fetish12310372fetish
fetor81214532fetor
fetors91014472fetors
fetuses10310242fetuses
feu67843662fe_u_
feud86523022fe_ud
feuds95914882feuds
fezes175220022fezes
ficus105015492ficus
fits76043462fit_s
flatus94310782flatus
flus75626542f_lus
focus105815882focus
frets85523402fret_s
fucus105515892fucus
fugus95914012fugus
genus65319832genus
getas65421482getas
gets55442482get_s
getup83410262getup
getups9346852getups
heths116317782heths
hets75547202het_s
ictus7249702ictus
jehus15488572jehus
jetes124922842jetes
jets115834102jet_s
lets47147942let_s
letup73712162letup
letups8317682letups
lotus55718062lotus
meatus85112922meatus
menus75822842menus
meous76120062meous
metes74736212metes
meths105320232meths
metis75025902metis
negus64513562negus
nets45941532net_s
netts55320722netts
nevus84611392nevus
nexus124710662nexus
pets66248332pet_s
rebus75721112rebus
rectus83314632rectus
rets45352562ret_s
retuse66617222retuse
setous64917372setous
sets45549502set_s
setts55124322setts
setup73915822setup
setups83910462setups
situs55019232situs
teths85418512teths
tets45847462tet_s
tutus55214812tutus
vatus86114642vatus
venus84918902venus
vertus94613602vertus
vets76835092vet_s
wets75940292wet_s
xerus12313332xerus
yetis85418392yetis
yetts86715132yetts
zebus164610052zebus
zetas145018162zetas

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 Filter178691538000.326548131.9
2DLD Change Limit538001191.65632487.9
3Display Results1191190.0303966.7
 (SQL Overall)1786911192.01288812.6
 
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.