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

154 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
defrost113955(None) 
defrosts1244831defrosts
dearest83618672dearest
deffest14308802deffest
deforest1238792deforest
defrock1744642defrock
defrosted1444252defrosted
defroster1343892defroster
deftest112611712deftest
frost84727832__frost
refront10313262refront
aerosat7417183ae_rosat
affront1357963affront
becrust1137983becrust
bedpost1247243bedpost
befret11315963befr_et
befrets1237613befrets
ceros74726073ce_ros_
daftest11248943daftest
deadest93014883deadest
deafest112911513deafest
dears65736883dear_s_
debris93311493debris_
decoct11313783de_coct
decors94017773decors_
decos85522123de_cos_
decrown13206053decrown
decrypt1545703decrypt
deepest10310443deepest
deers64930523deer_s_
defat95426693def__at
defats105114553defats_
default1147893default
defeat103817163def_eat
defeats113511233defeats
defect124816173def_ect
defects134511523defects
defense1137503defense
deferent122712873deferent
defers105116943defers_
defiant11311923defiant
deficit1339673deficit
defies104624053defies_
defis96717503def_is_
deflect13399973deflect
defoam1238563def_oam
defog1048523def_o_g
defogs1156683def_ogs
deforce13267243deforce
deforests1344373deforests
deform1259613def_orm
deforms1337803deforms
defrag1136463defr_ag
defrags1236193defrags
defraud1243913defraud
defray1337643defr_ay
defrays1436113defrays
defrocks1844113defrocks
defrosters1443363defrosters
defrosting1544493defrosting
deft85540223def___t
defunct1345773defunct
defuse105712723def_use
degust8310253de_gust
dehort104618103de_hort
dehorts11379773dehorts
deist64633593de__ist
dekkos1034103dekkos_
delist74625053de_list
demast9517063de_mast
demos86022993de_mos_
demurest1137453demurest
densest83112473densest
dentist8316743dentist
deorbit1048163deorbit
deport94922393de_port
deports105012883deports
depose94215763de_pose
deposit10313003de_posit
depot85727923de_po_t
depots94716343de_pots
depress10239863depress
derat65044083de_r_at
derats74625063de_rats
derms85022893de_rms_
derris73615273derris_
desist74818813de_sist
despot93413293despo_t
despots10319683despots
detest74122843de_test
detract101414633detract
devest104418703de_vest
devout10712993de_vout
dewiest11312343dewiest
dextrose1645363dextrose
diarist8517113diarist
direst75024243d_irest
disroot8413563disroot
dobros93910233dobros_
doorpost1165453doorpost
dost57248353d___ost
dourest8312943dourest
drest65530343d__rest
droit65127123d__roit
dropt86924433d__ropt
dross65418093d__ross
duros65422693d_uros_
durst66125173d_ur_st
effort1238623_effort
enroot6615993_enroot
eros45238453_e_ros_
erose55727273_e_rose
erst47436433_e_r_st
euros54920243_euros_
front85029223__front
frosh115713403__frosh
frosts94214623__frosts
frosty124710633__frosty
frowst125512073__frowst
genros74211333genros_
heros84930863he_ros_
leftest10269463leftest
leftist10279353leftist
leftmost1342583leftmost
leprose938543leprose
leprosy1244223leprosy
merest84725113me_rest
metrist9317063metrist
metros84217803metros_
nearest73415843nearest
necrose939723necrose
pedros9312183pedros_
prost75434103__prost
rearmost1047263rearmost
recross989833recross
redroot8312903redroot
refloat10310833refloat
reforest1139963reforest
refract121311603refract
refresh1335453refresh
refronts1137773refronts
refroze1956223refroze
repros84216003repros_
rerose63320843re_rose
retros63820193retros_
seafront1148023seafront
searest73322023searest
serest64831613se_rest
serosa6313023se_rosa
teleost7410523teleost
upfront1246973upfront
verist93823893ve_rist
verst84429373ve_r_st
zeros144918103ze_ros_

Search took 9 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.1561145455.1
2DLD Change Limit1340271547.80017182.9
3Display Results1541540.0463347.8
 (SQL Overall)1786911548.00222330.8
 
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.