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

254 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
focuser1215578(None) 
focused13166411focused
focusers13134371focusers
focuses12159651focuses
accuser11347932accuser
douser75621632do_user
excuser1635812excuser
ficuses12159202ficuses
focus105815882focus__
focussed14174042focussed
focusses13155222focusses
fouler93614902fo_uler
fucuses12158352fucuses
hocused13167012hocused
hocuses121710422hocuses
houser95322282ho_user
mouser85822442mo_user
nonuser7299142nonuser
rouser65224082ro_user
abuser85413683_abuser
accuse103411033accuse_
accused12368423accused
accusers12285903accusers
accuses114112193accuses
acuter84412863_acuter
amuser84712623_amuser
arcuses94814693arcuses
arouser74514423arouser
boluses94113833boluses
bonuses94212953bonuses
bouse75931853bo_use_
boused95322883bo_used
bouses84931783bo_uses
causer84117783_causer
chouser125212943chouser
coarser93211193coarser
cocker144320393coc_ker
cockier154013623cockier
conciser12310243conciser
coruler9311713coruler
coucher144515853coucher
courser94114803courser
couter84930203co_uter
crocuses1239023crocuses
cuber95222533__cuber
curer75030753__curer
curser84721473__curser
cusec94614903__cusec
cusser86016093__cusser
cuter74728223__cuter
defocused16143533defocused
defocuses15134493defocuses
defuser115110503defuser
docker134417653doc_ker
dorser74819173do_rser
doser66228563do__ser
dosser74417973do_sser
dourer74215273do_urer
douse66329723do_use_
doused84821163do_used
dousers84817273do_users
douses74928933do_uses
dowser104716083do_wser
excuse1537423excuse_
excused1736293excused
excusers1734443excusers
excuses1638903excuses
facer105525053fac__er
facular122810443facular
falser93912413f_alser
favuses1336183favuses
fetuses10310243fetuses
fickler16348423fickler
ficus105015493ficus__
figurer11215853figurer
flenser1036783flenser
flockier1745343flockier
flosser10339693flosser
flouter104311343flouter
flusher133012273f_lusher
fluster103913063f_luster
fluter95316863f_luter
foamer114714313fo_amer
foamier12339003foamier
focusing1436603focusing
focusless1452263focusless
fodder114712113fo_dder
foetuses1136083foetuses
fogger114414783fo_gger
foggier12349913foggier
folder104317543fo_lder
folkier14359043folkier
folksier1533533folksier
fonder104120063fo_nder
fondler11348883fondler
footer94320773fo_oter
footier104115113footier
footler104011873footler
foozler19397593foozler
forager114412563forager
forayer13368953forayer
forcer114917343fo_rcer
foresee10414333foresee
foreseer1139013foreseer
forester11313673forester
forever1338953forever
forger104820773fo_rger
forgoer1137693forgoer
forker134717903fo_rker
forkier144311583forkier
former114221403fo_rmer
fosse86119463fo_sse_
fosses96022083fo_sses
foster94322223fo_ster
fouled104315973fo_uled
founder114312563founder
four76226863fo_u__r
fowler123712583fo_wler
foxier163910033fo_xier
foyer116416553fo__yer
fozier183710663fo_zier
fucker153414423fuc_ker
fucose11167683fucose_
fucoses12148303fucoses
fucus105515893fucus__
fumer105918233f__umer
fuse76429993f__use_
fused94820443f__used
fusee86224583f__usee
fusel85218493f__usel
fuses85628423f__uses
fusser94813773f_usser
gouger86014363go_uger
grouser84513693grouser
hoarser10388393hoarser
hocker155118563hoc_ker
hocus104715203hocus__
hocussed14153793hocussed
hocusses13155303hocusses
hoser811529763ho__ser
house89131423ho_use_
housed105624103ho_used
housel95217043ho_usel
housers104717813ho_users
houses96032273ho_uses
incuse83513573incuse_
incused102911173incused
incuses93514853incuses
infuser10298323infuser
jocose1537103jocose_
jocular1637303jocular
jouster143311043jo_uster
locater93113603locater
locker124019423loc_ker
lockset13311163lockset
locular938953locular
locule83412033locule_
loculed10317653loculed
locules92812603locules
locus74819993locus__
locust85312343locus_t
locusta9326533locusta
locusts9277933locusts
looser65219943lo_oser
loser54728673lo__ser
lotuses74011253lotuses
louder74414603lo_uder
louse56131013lo_use_
loused74822913lo_used
louses66230283lo_uses
lousier72411623lo_usier
louver94110393lo_uver
misuser93210443misuser
mocker143315443moc_ker
momser104011413mo_mser
momuses1159263momuses
mosser84618273mo_sser
mouse77133003mo_use_
moused94423303mo_used
mousers95216443mo_users
mouses85531423mo_uses
mousey115216193mo_usey
mousier93712463mo_usier
mucuses11148513mucuses
muser76024123__muser
nonuse63212253nonuse_
nonusers8268003nonusers
nonuses73313863nonuses
nooser65517823no_oser
nouses64627163no_uses
obtuser9134453obtuser
ocher104516103_oc_her
ocker113915753_oc_ker
ocular8610133_ocular
onuses65616253_onuses
opuses84012243_opuses
ousel55222403_o_usel
ouster64223733_o_uster
outer55633303_o_uter
pauser84415963_pauser
peruser93511373peruser
pockier153911603pockier
pocosen1146833pocosen
poiser84217243po_iser
poser75128773po__ser
pourer84516043po_urer
pouter83923983po_uter
procurer1235833procurer
recuse85519163recuse_
recused104714423recused
recuses94619463recuses
refocused15144653refocused
refocuses14135953refocuses
refuser104912783refuser
robuster1035663robuster
rocker124319573roc_ker
rockier134911883rockier
rooser63921883ro_oser
rouse56634703ro_use_
roused75426443ro_used
rousers75220133ro_users
rouses65436283ro_uses
rouster73517083ro_uster
router65025843ro_uter
scourer93910433scourer
scouse84113633scouse_
scouses93313243scouses
scouter93313323scouter
securer958253securer
socager10107703socager
soccer1038543soc_cer
sourer63620213so_urer
souse56530773so_use_
soused74822983so_used
souses64229243so_uses
souter64225923so_uter
tocher114014913toc_her
tonuses73612193tonuses
tosser64215663to_sser
toucher124814353toucher
tourer64115073to_urer
touse55430673to_use_
toused74122013to_used
touses64229673to_uses
touter63821033to_uter
trouser73812463trouser
unfocused1553393unfocused
user45023003___user
vocoder1334693vocoder
voguer10468403vogu_er
voucher154110263voucher
worser95117523wo_rser
wowser125110203wo_wser
youse85322233yo_use_

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 Limit1340272547.90616952.6
3Display Results2542540.0763342.1
 (SQL Overall)1786912548.13821957.6
 
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.