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 “preplan” 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
preplan114995(None) 
preplans1249611preplans
preplant12712911preplant
replan83215821_replan
pepla9312862p_epla_
pieplant1268732pieplant
preclean1245892preclean
prelaw1139102pre_law
preman104117452pre_man
prepay13310312prep_ay
preplace1488982preplace
prolan8414692pr_olan
propman1339062propman
replans92814942_replans
replant93318532_replant
replay113412922_replay
trepan82511672trep_an
areola6813673areola_
areolae7811733areolae
areolar779223areolar
areolas71013863areolas
arepa75615563arep_a_
arepas85515703arep_as
avellan1037293avellan
brechan1437223brechan
capelan1139003capelan
crepon1039943crep_on
crewman1435753crewman
cropland1346303cropland
deplane10311413_deplane
elan46734243__e_lan
erepsin937383erepsin
firepan1236983firep_an
foreplay1645673foreplay
freeman1237343freeman
frypan1434543fryp_an
graplin1058443graplin
gremlin1035563gremlin
greylag1262553greylag
gripman1234463gripman
kremlin1344213kremlin
kreplach1942613kreplach
misplan1147773misplan
orphan1137733or_phan
ortolan747083ortolan
outplan9249443outplan
overplan13258943overplan
paean77222723pae__an
paella8410913paella_
paellas9411413paellas
paesan85114093pae_san
pampean1335543pampean
pean66147173p_e__an
pecan91919033p_e_can
pechan13511543p_echan
pedlar93311273p_edlar
pekan111613973p_e_kan
pelon74423213p_e_lon
peneplain13113943peneplain
peneplane1344663peneplane
penman10312323p_enman
peplos101211543p_eplos
peplum12156823p_eplum
peplus10138343p_eplus
pepsin10310853p_epsin
permian112612283permian
perplex1836153perplex
pieplants1355433pieplants
plan65833943___plan
poplar103611113p_oplar
poplin10413483p_oplin
preanal9310713preanal
precleans1344893precleans
preclear1245423preclear
predawn1335353predawn
predial103815413predial
preen75925053pre__en
prefab1336243pre_fab
preflame1545913preflame
prefrank1764233prefrank
pregnant1149883pregnant
preheat12413893preheat
prehuman1545033prehuman
prelacy1437583pre_lacy
prelate9519693pre_late
prelim10311423pre_lim
preload1049813preload
premeal11310523premeal
premen105017803pre_men
premolar1246633premolar
prenoon9310043prenoon
preoral9312673preoral
prep86427673prep___
prepack1757643prepack
prepaid12310133prepaid
prepare111913623prepare
prepave14228873prepave
prepays1437483prepays
prepill1147583prepill
preplaced1676483preplaced
preplaces1578753preplaces
preplacing1746003preplacing
preplanned1543503preplanned
prepped11329903prepped
preppie1058093preppie
prepping12309763prepping
preppy1235523prep_py
prepreg12165963prepreg
preprint12314183preprint
preps96220693prep__s
prepuce1337833prepuce
prepupa1064023prepupa
prepupae1144643prepupae
prepupal1164263prepupal
prepupas1144133prepupas
presa74319043pre_sa_
presale9416353presale
presoak1348453presoak
presplit1247753presplit
pressman1247153pressman
pretax152310193pre_tax
preteen939873preteen
pretrain10310923pretrain
prewar114712583pre_war
prewarn124410153prewarn
preworn124711223preworn
prewrap14104973prewrap
priapean1243373priapean
prolans9314273pr_olans
propane112716153prop_ane
propmen1338763propmen
propyla14296633propyla_
propylon1544873propylon
protean92412193protean
raglan73711503_raglan
reclad9311873_reclad
reclean938523_reclean
redan66125013_re_dan
reflag1098083_reflag
reland75920433_re_land
relax124817803_re_lax
relay84424673_re_lay
reloan6415693_reloan
reman75730153_re_man
repand95316063_rep_and
repay104818453_rep_ay
repeal84718283_repeal
repeat85127213_repeat
repin75324703_rep_in
replace113214283_replace
replants102811243_replants
replate93420053_replate
replays12399763_replays
replead10399013_replead
repled93319783_repled
replot83818593_replot
replow114210343_replow
reply104015853_repl_y
reptant92817073_reptant
repugn946493_repugn
reran57329103_re_ran
rewan85623663_re_wan
trapan82412973trap_an
treelawn1142713treelawn
trepang10257293trep_ang
trepans92311593trep_ans
triplane1039113triplane
triptan947543triptan
urethan1045473urethan

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271696.62320236.6
3Display Results1691690.0632682.5
 (SQL Overall)1786911697.09225196.1
 
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.