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

205 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
deporter116939(None) 
deported1249701deported
deportee11510351deportee
deporters1277791deporters
reporter10411421reporter
deforcer14246902deforcer
deformer14247942deformer
dehorner1235522dehorner
dehorted1357302dehorted
departed1238822departed
departee1139722departee
depicter1356852depicter
depleter11298862depleter
deplorer1136342deplor_er
deport94922392deport__
deportees1256642deportees
deports105012882deport_s
deposer104011842depo_ser
deserter91211602deserter
devouter1235512devouter
dewormer14256322dewormer
exporter1737362exporter
importer12308912importer
porter84224412__porter
reported11312702reported
reporters1139172reporters
resorter8312182resorter
retorter8410732retorter
sporter93616552_sporter
aborter939933_aborter
adepter1036113adep__ter
assorter866673assorter
cavorter1335783cavorter
darter75320363d__arter
dearer74822803de_ar_er
debarker15155503debarker
debater104114693de_bater
deboner103110483debo_ner
decanter112510793decanter
decenter112412163decenter
decocted1437693decocted
decoder113712293deco_der
decorate11315193decorate_
decorated13312213decorated
decorates12314743decorates
decorator1248573decorator
decoyer13348683deco_yer
decreer10269123de_creer
decrier102713563de_crier
deemster1175713deemster
deepwater1543713deepwater
defeater122611663defeater
deferrer12135593deferrer
deflater123211603deflater
defoamer14276213defoamer
defogger1443533defogger
deforce13267243deforce_
deforced15247373deforced
deforcers15265503deforcers
deforces14248403deforces
deformed15248263deformed
deformers15266533deformers
defroster1343903defroster
defter104215923de__fter
dehorned1345683dehorned
dehorners1344743dehorners
dehort104618103dehort__
dehorts11379773dehort_s
delouser936363delouser
deluster936903deluster
demerger12127373demerger
demister11310223demister
demote94817803demo_te_
demoted114313543demo_ted
demotes104717673demo_tes
dempster1355773dempster
demurer1037873demur_er
demurrer1144043demurrer
denote74118043deno_te_
denoted93512763deno_ted
denotes83817003deno_tes
depart94720563depart__
departees1265723departees
departs104310683depart_s
departure1243803departure
depermed1436453depermed
depicted1437743depicted
depicters1435823depicters
depictor1355513depictor
deplete103010423deplete_
depleted12258723depleted
depleters12327543depleters
depletes112810643depletes
deplore1039483deplor_e_
deplored1237233deplor_ed
deplorers1245463deplor_ers
deplores1139533deplor_es
deployer1445633deployer
depone93616553depo_ne_
deponed113712873depo_ned
depones103717093depo_nes
deporting1369593deporting
deportment1546773deportment
depose94215763depo_se_
deposed113412033depo_sed
deposers11359243depo_sers
deposes103117213depo_ses
deposited1346783deposited
depositor1244443depositor
depot85727923depo_t__
depots94716343depo_t_s
depraver1435413depraver
depriver1446293depriver
depurate1139983depurate_
depurated1338183depurated
depurates1239823depurates
depurator1247023depurator
depute94512303dep_ute_
deputed114610173dep_uted
deputes104911783dep_utes
desalter938363desalter
descrier1157623descrier
deserted101012203deserted
deserters10129983deserters
deserver12118383deserver
desirer8310783desir_er
desolater1038383desolater
desorbed1236443desorbed
despoiler1243963despoiler
destrier9311823destrier
detecter11298733detecter
deter65028043de___ter
deterger10147593deterger
deterrer9137013deterrer
detester9239683detester
devote104513783devo_te_
devoted124111093devo_ted
devotee113811823devo_tee
devotes113713753devo_tes
devourer1235063devourer
dewater112912423de_water
dewormed15236223dewormed
dewormers15255193dewormers
dexter143810893de__xter
diopter1038473d_iopter
disorder1038133disorder
disported13310303disported
distorter1048403distorter
diverter12238623diverter
divorcer1444033divorcer
dopester1137253dopester
dormer94415903d__ormer
dorper94314573d__orper
dorser74819183d__orser
doter65428623d__o_ter
dotter74419343d__otter
emoter85415193_emo_ter
exhorter1845353exhorter
exported1837133exported
exporters1846253exporters
extorter1546513extorter
imparter12357543imparter
imported13308693imported
importers13247763importers
imposter12288163imposter
memoriter13126573memoriter
pearter9412743pe_arter
perter84422283__perter
porker124917543__porker
ported94223243__ported
porters93722703__porters
poster84129173__poster
potter83926983__potter
pouter83923983__pouter
powter114116033__powter
recorder11249633recorder
reformer13217953reformer
remoter94815973remo_ter
reorder8239483re_order
repartee10312753repartee
repeater102615443repeater
repenter102813863repenter
report85326023report__
reports94916213report_s
reposer93715333repo_ser
repotted1139283repotted
repower12329883repo_wer
reprover13229203reprover
resorted9313493resorted
resorters939693resorters
retorted9312333retorted
retorters938773retorters
reverter114812873reverter
revolter11279363revolter
shorter103515503_shorter
snorter74412663_snorter
sorter64425093__sorter
sported104015433_sported
sporters103714063_sporters
sportier102010053_sportier
spotter94514883_spotter
spouter94213223_spouter
spurter94013003_spurter
supporter1344513supporter
vaporer1236983vapor_er

Search took 8 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 Filter1786911461620.453394461.4
2DLD Change Limit1461622057.34319904.9
3Display Results2052050.0762697.4
 (SQL Overall)1786912057.87222699.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.