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

227 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
crispier1229725(None) 
crimpier14287321crimpier
crisper113511051crisp_er
chippier17297672chippier
chirpier15276302chirpier
crampier14288902crampier
crappier14288132crappier
creepier1236252creepier
crepier1139732cr_epier
crimper136510422crimp_er
crippler14826712crippler
crisped124010102crisp_ed
crispen11348202crisp_en
crispers12309432crisp_ers
crispiest13197422crispiest
crispily1574692crispily
crisping13319662crisping
crosier94116572cros_ier
croupier1246882croupier
crustier10259532crustier
drippier1385042drippier
friskier1535192friskier
gripier103210322gri_pier
grippier1355202grippier
grislier935792grislier
prissier10157872prissier
raspier93110632_raspier
riskier1138422_riskier
scrimpier1554242scrimpier
trippier1246622trippier
wispier12249402_wispier
wristier1136862wristier
acrospire1343963acrospire
artsier768943arts_ier
brashier13389933brashier
brasier94516753bras_ier
brassier103310533brassier
brickier16307163brickier
brinier93613463bri_nier
brisker134210293bris_ker
bristlier1144313bristlier
brushier13306973brushier
campier133313273c_ampier
cashier123713323c_ashier
chestier1387423chestier
chichier1836023chichier
chillier13328423chillier
chinkier17377363chinkier
chipper163912583chi_pper
chippie16297693chippie_
chippies17309753chippies
chirper14359963chirp_er
chiseler1335903chiseler
choppier17286643choppier
christie1347783christie_
christies1449263christies
cipher133710263c_i_pher
cissies94116153c_issies
clasper113811863clasp_er
classier10359083classier
cliffier1633913cliffier
clingier1155853clingier
clipper133710323cli_pper
cliquier1944223cliquier
clumpier1435583clumpier
conspire1257873conspire
conspirer1355293conspirer
copier103722893c__opier
cosier84423753c_os_ier
crabbier14326803crabbier
craftier1376193craftier
craggier12116063craggier
crankier14339163crankier
crapper133913193cr_apper
crappie13298983crappie_
crappies142911153crappies
crasher124616153cras_her
crasser94114333cras_ser
crawlier13216873crawlier
crazier183610743cr_azier
creakier14328333creakier
creamier12319063creamier
creasier103210193creasier
creeper11339973creep_er
creepie1137483creepie_
creepies1239613creepies
cribber13367663cri_bber
crier74724463cr___ier
crimmer133310773cri_mmer
crimped143910763crimp_ed
crimpers14318933crimp_ers
crimpiest15237183crimpiest
crimping15299783crimping
crimple13408693crimple_
crimpled15366933crimpled
crimples14308963crimples
cringer103514243cri_nger
crinklier1543843crinklier
cripe95521143cri_p_e_
cripes105120873cri_p_es
cripple13378583cripple_
crippled15336793crippled
cripplers15314993cripplers
cripples14298403cripples
crises84529433cris__es
crisic103611843cris_i_c
crisis83716343cris_i_s
crisp95014623crisp___
crispate1246913crispate
crispated1445023crispated
crispened1443613crispened
crispens12286253crispens
crispest12177373crispest
crisphead1742663crisphead
crispiness1444793crispiness
crisply14426523crisp_ly
crispness1345303crispness
crisps104411513crisp__s
crispy13478563crisp__y
cristae9310603cristae_
critter94113033cri_tter
croakier14436263croakier
cropper133312963cr_opper
croppie13278793croppie_
croppies143111133croppies
crosiers103312053cros_iers
crosser95015463cros_ser
croupiers1334633croupiers
crozier18369933cr_ozier
cruddier1244153cruddier
cruiser93410433cruis__er
crumbier1456363crumbier
crummier1435603crummier
crumplier1543783crumplier
crupper13338563cr_upper
crusader1144263crusader
crusher124412323crus_her
cuppier1368323c_uppier
cushier123610833c_ushier
dippier123111393_dippier
dishier113613403_dishier
dressier956863dressier
driftier1275123driftier
dripper12349223dri_pper
droopier1145573droopier
drossier956313drossier
feistier1136193feistier
fishier13359853_fishier
frillier1136513frillier
fringier1236543fringier
frisker14389273fris_ker
frizzier19284813frizzier
frostier1148163frostier
frumpier1534173frumpier
gimpier12247943_gimpier
grapier103712603gr_apier
grasper10389783grasp_er
grassier9349283grassier
grimier103210433gri_mier
griper94114613gri_p_er
gripper124410713gri_pper
grister83915413gris_ter
gristlier1044283gristlier
grittier9316263grittier
grumpier1334803grumpier
hippier143212103_hippier
hissier103410503_hissier
lippier112710573_lippier
lisper84114433_lisp_er
mistier93418713_mistier
nippier11319833_nippier
noisier759453nois_ier
pipier104913983_pi_pier
preppier1156643preppier
pricier113313113pri_cier
prickier16368143prickier
prisoner1048573prisoner
prissies101712003prissies
privier122910453pri_vier
prosier93817483pros_ier
prosper114012183prosp_er
quippier2133773quippier
rapier84019993_r_apier
rasper83917323_rasp_er
respire9411543_respire
ribbier1137593_ribbier
ribier84414233_ri_bier
ridgier937883_ridgier
rimier83916273_ri_mier
riper74328403_ri_p_er
ripper103518653_ri_pper
rippler113210103_rippler
ripplier1234463_ripplier
riser55431053_ris__er
risker105414493_ris_ker
ritzier16297203_ritzier
ropier84118803_r_opier
rosier64221263_ros_ier
roupier9319493_roupier
rushier103411973_rushier
rustier74416363_rustier
scrappier1544413scrappier
scrimper1455753scrimp_er
scripter12137773scri_pter
shrimpier1643063shrimpier
sirupier1034303sirupier
sissier73711363_sissier
skimpier1634293skimpier
slippier1256533slippier
snippier1255793snippier
spier75728033___spier
stripier1058853stri_pier
swishier1434563swishier
tippier113210543_tippier
tipsier9268893_tipsier
trampier12318233trampier
trashier113210093trashier
tressier847963tressier
trickier143010233trickier
tripper113711923tri_pper
trustier8268683trustier
twistier1134813twistier
waspier12259053_waspier
whippier18265823whippier
whisper15298013whisp_er
wimpier14248053_wimpier
zippier20308193_zippier

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.1701051123.5
2DLD Change Limit1461622277.94018408.3
3Display Results2272270.0932440.9
 (SQL Overall)1786912278.20321783.6
 
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.