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

140 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
remodels113566(None) 
remodel1038091remodel_
models94216352__models
recodes102918632recode_s
remodeled1344722remodeled
remodeler1243922remodeler
remodelers1342792remodelers
remotely1345622remotely
remotes94521612remote_s
removals1345642removals
removers13449222removers
removes124514712remove_s
aerogels945593aerogels
bedels94015273be__dels
damosels11195233damosels
damozels20133163damozels
decoders122810413decoders
decodes113914983decode_s
demode104013463demode__
demoded123611123demode_d
demoness1138053demoness
demoses103815823demose_s
demotes104717673demote_s
dreidels1033213dre_idels
elodeas836963_elodeas
embowels15224133_embowels
emodins1039433_emodins
emoters94712873_emoters
emotes84620283_emote_s
emydes1236173_emyde_s
epodes94315563_epode_s
erodes74819883_erode_s
gemotes103712143gemote_s
geodes8412153ge_ode_s
hemocoels1643533hemocoels
modals93914443__modals
model84521693__model_
modems114610763__modems
modes85537413__mode_s
mohels115011323__mohels
morels84820013__morels
motels83616893__motels
oenomels1044583oenomels
precodes13711573precode_s
premodern1444423premodern
ramosely1344223ramosely
readers83823763re_aders
rebels84518133re__bels
rebodies1139153rebodies
reboils94111713rebo_ils
rebores95319163rebore_s
recedes102816063recede_s
recoals94214623reco_als
recode93618713recode__
recoded113115033recode_d
recoils93814873reco_ils
recorders12187953recorders
recovers133511123recovers
reddens9259783re_ddens
redders93615343re_dders
reddles93315773re_ddles
redes65139123re__de_s
redoes74623753redo_e_s
redoxes15310883redoxe_s
reels55333263re___els
reexpels1752503reexpels
refeels10379693re_feels
refels94618053re__fels
refuels10399523re_fuels
regosols944323regosols
reheels10298253re_heels
relabels1045343relabels
reloaders1036413reloaders
remade94316983remade__
remails94714563rem_ails
remakers143811303remakers
remakes134116173remake_s
remates93827103remate_s
remedies11310553remedies
remeets93712413rem_eets
remelt85123123rem__elt
remelts93511493rem__elts
remiges103015473remige_s
reminders12308653reminders
remises93423483remise_s
remixes164313873remixe_s
remodeling1445023remodeling
remodelled1443113remodelled
remodify1743953remodify
remolades1246563remolade_s
remold93412973remo__ld
remolded1237403remolde_d
remolds10299703remo_lds
remoras9314073remo_ras
remorses10311993remorses
remote84222603remote__
remoter94815973remote_r
remotest103310723remotest
remounts1036373remounts
removal1236733removal_
remove116115573remove__
removed134611313remove_d
removedly1842833removedly
remover124612273remove_r
remudas1035833remud_as
renders83821673re_nders
reoils64516873re_o_ils
reopens939373re_opens
reorders9198833reorders
repanels1036783repanels
repels84318763re__pels
repolls939053repo_lls
reposals1037403reposals
reposers102911603reposers
reposes94021263repose_s
repowers13288533repowers
rerolls739943rero_lls
residers93311883residers
resides84523283reside_s
resods74116303resod__s
resojets1535343resojets
resolders10258013resolders
resoles73823653resole_s
retools73411023reto_ols
retotals838463retotals
revels94220573re__vels
revokers15366753revokers
revokes144212503revoke_s
revotes104716393revote_s
rewidens1235533rewidens
rezones163213943rezone_s
rimosely1343943rimosely
rodeos75314503r__odeos
rodes614039083r__ode_s
rondels82510053r_ondels
roundels9217743roundels
rowels94515453r__owels
seidels838393se_idels
wedels103811033we__dels
yodels104610073__yodels

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621407.96618348.2
3Display Results1401400.0463043.5
 (SQL Overall)1786911408.16821877.0
 
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.