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

125 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
preplaces157875(None) 
preplace1488981preplace_
preplaced1676481preplaced
replaces123114121_replaces
fireplaces1744342fireplaces
prefaces15311062pre_faces
prelacies13310052pre_lacies
prelates10418572pre_lates
prepacks1836582prep_acks
prepares122014162prep_ares
prepaves15189192prep_aves
preplans1249612prepla_ns
preprices1569262preprices
prepuces1438582prep_uces
preslices1338212preslices
relaces93420882_re_laces
replace113214282_replace_
replaced133211402_replaced
replacer12279742_replacer
replacers13266832_replacers
replates102919272_replates
deplanes11311213_deplanes
displaces1448593displaces
emplaces1438413_emplaces
enlaces92313393__enlaces
fireplace1644873fireplace_
fireplaced1842943fireplaced
freelances1545223freelances
homeplaces1944383homeplaces
kreplach1942613kreplac_h
misplaces1537953misplaces
outplaces1347743outplaces
palaces114216463p__alaces
peaces106324083p_e__aces
pelages10714613p_e_lages
peneplanes1444323peneplanes
peploses1269473p_eploses
pepluses1287023p_epluses
perplexes2044683perplexes
pieplants1355433pieplants
places104323703___places
populaces15195713populaces
preaches153214893pre__aches
preacts113211363pre__acts
prebakes1639013pre_bakes
precludes1445053precludes
predates11615813pre_dates
preelects1356083preelects
preenacts1345843preenacts
preface14510923pre_face_
prefaced1638423pre_faced
prefacer1537983pre_facer
prefacers1636293pre_facers
prefades1439533pre_fades
preflame1545913preflame_
pregames1339003pre_games
prelacy1437583pre_lac_y
prelate9519693pre_late_
prelects1299723pre_lects
prelives13310383pre_lives
preludes1137833pre_ludes
prenames12311643pre_names
prentices131111903prentices
prepack1757643prep_ac_k
prepacked20155653prep_acked
prepare111913623prep_are_
prepared132210873prep_ared
preparer12169643prep_arer
preparers13197673prep_arers
prepastes13128823prepastes
prepave14228873prep_ave_
prepaved16177233prep_aved
prepays1437483prep_a_ys
preplacing1746003preplacing
preplan1149953prepla__n
preplanned1543503preplanned
preplant12712913prepla_nt
preppies1149693prep_pies
preprice1488873preprice_
prepriced1676643prepriced
preprocess1644053preprocess
prepubes1436053prep_ubes
prepuce1337833prep_uce_
prepunches1954013prepunches
prerace11414123pre_race_
presages11312203pre_sages
presales10315263pre_sales
presences132113793presences
preshapes1667093preshapes
preslice1258623preslice_
presliced1435983presliced
pretapes122811533pre_tapes
pretences132312613pretences
prevalues1445323prevalues
propanes122415823prop_anes
prophages1749763prophages
prophases16411063prophases
reclames12310893_reclames
refaces123216743_re_faces
reflates113115663_reflates
reglazes1846793_reglazes
relace83122153_re_lace_
relaced103517213_re_laced
relates73731433_re_lates
relaxes143215323_re_laxes
repacks15269543_rep_acks
repaves123513653_rep_aves
replans92814943_repla_ns
replants102811243_replants
replate93420053_replate_
replated112817523_replated
replayed14248633_replayed
replays12399763_repla_ys
repletes102812473_repletes
replicas1237093_replicas
replies94521043_repl_ies
reprices122913353_reprices
reslates83619503_reslates
respaces12311043_respaces
resplices1336623_resplices
retraces101417273_retraces
someplaces1644083someplaces
toeplates1147183toeplates
triplanes1148803triplanes
workplaces2152533workplaces

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411257.48319863.8
3Display Results1251250.0631984.1
 (SQL Overall)1786911257.96922423.3
 
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.