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

169 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
reposal93911(None) 
deposal1037151deposal
reposals1037411reposals
deposals1145442deposals
exposal1645312exposal
proposal1247742proposal
recoal84117982reco_al
recusal968682recusal
refusal1056892refusal
regosol844882regosol
removal1236732removal
repeal84718292rep_eal
repoll8410792repo_ll
repos74725792repos__
repose84121412repos_e
reposed103616282reposed
reposer93715332reposer
reposes94021262reposes
reposit9315862reposit
reprisal1045902reprisal
reproval1355772reproval
retotal739842retotal
revisal1038262revisal
serosal7311152serosal
aerosat7417183aerosat
aerosol747683aerosol
apodal9289833_apodal
caporal11410943caporal
creosol946053cre_osol
deposable1446833deposable
depose94215763depos_e
deposed113412033deposed
deposer104011843deposer
deposes103117213deposes
deposit10313003deposit
despisal1144673despisal
devisal1136913devisal
disposal1147023disposal
ephoral1248403_ephoral
epical10413393_epical
epochal1445243_epochal
epos66723733_epos__
eposes84418783_eposes
espousal1083013espousal
exposals1744053exposals
femoral1238723femoral
hexosan1744333hexosan
medusal1035183medusal
mensal84615663me_nsal
mucosal11155843mucosal
neurosal845843neurosal
pedocal1237893pedocal
pepos96620083pepos__
peroral9314793peroral
perusal939193perusal
petrosal1047153petrosal
postal84317533__postal
prebasal1244723prebasal
premoral1249713premoral
preoral9312673pre_oral
prepupal1164263prepupal
proposals1346673proposals
real45750293re___al
rearousal943493rearousal
reassail845753reassail
reboil83814683rebo_il
recital9412173recital
recoals94214633reco_als
recoat84024273reco_at
recoil84016723reco_il
rectal84418143re_ctal
recusals1056403recusals
redial74923113re_dial
redos65126763redos__
redowa1038453redowa_
redowas1138393redowas
redpoll1045043redpo_ll
refusals1164913refusals
refutal1046943refutal
regal65023793re__gal
reginal84814293reginal
regional9438783regional
regnal74812933re_gnal
regosols944323regosols
reload7413893relo_ad
reloan6415693relo_an
remodel1038093remodel
remora8414593remora_
remoras9314073remoras
removals1345653removals
renal55929513re__nal
renewal1038713renewal
rental63922033re_ntal
reoil55321183re_o_il
repanel939963repanel
repass84114703repas_s
repast83520633repas_t
repasts93611933repasts
repay104818453rep__ay
repeals94014533rep_eals
repeat85127213rep_eat
repel74921403rep__el
replan83215823rep_lan
replay113412923rep_lay
replead10399013replead
repo66027543repo___
repolls939053repolls
report85326023repo_rt
reports94916213reports
reposedly1543403reposedly
reposeful1452603reposeful
reposers102911603reposers
reposing111213803reposing
reposits10310453reposits
repot75132623repo__t
repots85621003repo_ts
repour8310993repo_ur
repours9310233repours
repousse1046053repousse
repower12329883repower
repps95114343repps__
reprisals1144563reprisals
repros84216003repros__
reprovals1444883reprovals
reps65937953rep_s__
reroll6412683rero_ll
rerose63320853reros_e
resail64418733re__sail
resale64025543re__sale
resat55139683re__sat
resaw84117253re__saw
resay85320543re__say
reseal64819653re_seal
resoak10311093reso_ak
responsa1043593responsa_
respool937643respo_ol
restoral8810983restoral
retial64724993re_tial
retinal75318353retinal
retool63914483reto_ol
retotals838463retotals
retral64419743re_tral
retrial7615553retrial
reveal94115063re_veal
reversal1145853reversal
revisals1136813revisals
revival1337033revival
ripost83615003ripos_t
riposte9269623riposte
riposts9279403riposts
ripsaw1134283rip_saw
royal85014703r__oyal
rugosa734563rugosa_
rugosas844973rugosas
seconal9310073seconal
sepal77723003sep__al
septal84513383sep_tal
serosa6313023serosa_
serosae7310253serosae
serosas7312663serosas
sponsal946343_sponsal
sporal82915453_sporal
spousal965533_spousal
supposal1244913supposal
temporal1246333temporal
tepal76319583tep__al
tripodal1145143tripodal
uropodal1144163uropodal
versal93013753ve_rsal

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.406440125.6
2DLD Change Limit1340271697.56317721.4
3Display Results1691690.0632682.5
 (SQL Overall)1786911698.03222247.4
 
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.