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

265 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
ceriph139846(None) 
ceriphs1484751ceriphs
caliph13311402caliph
ceria75125362ceri_a
cerias83321982cerias
ceric94023092ceri_c
cering94522532cering
cerise84822042cerise
cerite84724872cerite
cerium10313772cerium
cherish15310462cherish
cripe95521142c_ripe
perish114619062perish
seraph114011162seraph
teraph11319092teraph
aerial64625713aerial
aerie54634603aeri_e
aeried74221873aeried
aerier64823163aerier
aeries64737783aeries
aerify122810113aerify
aerily93017013aerily
atrip75315753atrip_
bearish123013273bearish
berime105317333berime
berth104917883ber_th
brith104924373_brith
caliphs1436753caliphs
caph116623293c__aph
caribe103416753caribe
caried94528693caried
caries85147623caries
carina84325333carina
caring95137993caring
carlish12312773carlish
caroch13911763caroch
carp85139813car_p_
carpi94319393car_pi
carps96932253car_ps
cebid104314073cebi_d
cebids11439173cebids
cecity1398153cecity
cedi74919273cedi__
ceding104014803ceding
cedis84317083cedi_s
ceiba938703ce_iba
ceil65725063ce_i_l
ceili75814793ce_ili
ceilidh1345363ceilidh
ceils75019403ce_ils
celiac101910433celiac
ceorlish1345383ceorlish
cep75736333ce__p_
cepe84926653ce__pe
ceps86125953ce__ps
cerate84829463cerate
cercal10314123cercal
cerci93716393cer_ci
cercis104614493cercis
cercus105013153cercus
cere66741473cer__e
cereal8315833cereal
cered85227443cer_ed
ceres75540013cer_es
cereus85215523cereus
cerises94722253cerises
cerites94823433cerites
ceriums1139483ceriums
cermet10321153cermet
cero66329453cer__o
ceros74726073cer_os
cerous85821203cerous
certes84623083certes
certify1546243certify
ceruse83914523ceruse
cervid1239323cervid
cervine122610803cervine
cervix1865163cervix
cesium1039583cesium
ceviche1744143ceviche
chip116726423c_hip_
chips125721253c_hips
chirp124717163chirp_
chirps135414003chirps
chirpy16498913chirpy
chrism13710673chrism
cleric10612133cleri_c
clerics1149333clerics
clerid9312413cleri_d
clerids1049093clerids
clerisy1246823clerisy
clerkish1744263clerkish
clip86924003c_lip_
clips96018303c_lips
clipt96324273c_lipt
coria75828323cori_a
coring94433963coring
corium10315723corium
corps95927043cor_ps
coyish143710393coyish
crap85731843c_rap_
crape96128443c_rape
craps95328643c_raps
crash109120013c_rash
creep95218103creep_
creeps104213623creeps
creepy13418803creepy
creesh11328333creesh
crepe95520723c_repe
crept95125893c_rept
crepy124812703c_repy
crib86323583c_ri_b
cribs94516753c_ribs
crick135118753c_rick
cried84624293c_ried
crier74724463c_rier
cries75438403c_ries
crime94822693c_rime
crimp115615803c_rimp
crimps124613453c_rimps
crimpy15489393c_rimpy
cripes105120873c_ripes
cris66233433c_ri_s
crisp95014623c_risp
crisps104411513c_risps
crispy13478563c_rispy
crit65743713c_ri_t
crits75527573c_rits
crop87628633c_rop_
crops96125243c_rops
crush106815993c_rush
crwth1337483c_rwth
crypt123715233c_rypt
cuish10313173c_uish
curagh1236553curagh
curch124415413cur_ch
curia74523783curi_a
curiae84518373curiae
curial84019153curial
curie74533043curi_e
curies84934023curies
curing94824783curing
curio74221213curi_o
curios83218333curios
curite85222943curite
curium10312503curium
currish1238353currish
delish105215613delish
deride84420033deride
derive103817043derive
dervish1436983dervish
dreich12377723dreich
dreigh11246443dreigh
drip76223953_drip_
drips85417233_drips
dript86923873_dript
eerie55228533eeri_e
eerier64320023eerier
eerily92913563eerily
enrich1138943enrich
erica7316543_erica
erupt74220063_erupt
euripi856083euripi
feria85922713feri_a
feriae95618603feriae
ferial94621253ferial
ferias95020393ferias
ferine96422583ferine
ferity122813343ferity
fetich1479693fetich
fetish12310373fetish
frith115922033_frith
garish104516923garish
genip84415203genip_
genips9469943genips
gerah9315303ger_ah
graph115315613_graph
grip76127023_grip_
gripe84622963_gripe
grips85520133_grips
gript85126173_gript
gripy115115253_gripy
grith95520373_grith
heigh124812543he_igh
heriot9422343heriot
jerid132316423jeri_d
jerids142810943jerids
kaliph1537873kaliph
marish114319053marish
megilph1542263megilph
merch125417963mer_ch
merino8315093merino
merit7339183meri_t
merits8320873merits
morph121712513mor_ph
neigh94912383ne_igh
nerdish1137103nerdish
newish1237903newish
ogrish1039263ogrish
paraph13311263paraph
pariah114320583pariah
parish115022353parish
perch124518833per_ch
peri65636973peri__
periapt11313413periapt
peril75425953peri_l
perils84121853perils
period9314983period
peris75537073peri_s
periti8319953periti
perkish16258823perkish
perp89029893per_p_
perps95521483per_ps
recipe103414893recipe
redip87816963redip_
redips93713843redips
redipt94116743redipt
relish93916953relish
rerig64018483reri_g
rerigs74014793rerigs
rerise64325633rerise
rich97025543__rich
rip56851303__rip_
ripe66038923__ripe
rips66237433__rips
scarph13429603scar_ph
scrip96619193scrip_
scrips105316033scrips
script105717903script
serape84818413serape
seraphs12408093seraphs
serfish1348973serfish
serial64625863serial
series64540973series
serif84132133seri_f
serifs94017053serifs
serin55434443seri_n
serine65432673serine
sering74731813sering
serins64029673serins
strip77524343strip_
stripe85822443stripe
strips85719653strips
stript85222193stript
stripy115812743stripy
thrip103012183thrip_
thrips11299013thrips
trip66830393_trip_
tripe75425383_tripe
trips74923363_trips
unrip72012863unrip_
unripe82012093unripe
unrips8199453unrips
verier94620963verier
verify153110163verify
verily122616053verily
verism113214263verism
verist93823893verist
verite94323443verite
verity123714853verity
wearish132310153wearish
weigh125412513we_igh
xeric144315663xeri_c
zenith1839073zenith
zeroth1837963zeroth

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162654.93622835.5
3Display Results2652650.0803312.5
 (SQL Overall)1786912655.39233140.0
 
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.