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

157 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
ceriphs148475(None) 
ceriph1398461ceriph_
caliphs1436752caliphs
cerias83321982ceri_as
cerises94722252cerises
cerites94823432cerites
ceriums1139472ceriums
cripes105120872c_ripes
seraphs12408092seraphs
aerials74017553aerials
aeries64737783aeri_es
berimes115216643berimes
berths114712423ber_ths
briths115113863_briths
caliph13311403caliph_
caphs124515373c__aphs
caribes113715643caribes
carices114220953carices
caries85147623cari_es
carinas93622413carinas
carious93320283carious
caritas93316963caritas
carps96932253car_p_s
carpus105514303car_pus
cebids11439173cebi_ds
cedis84317083cedi__s
ceibas1038503ce_ibas
ceilidhs1442133ceilidhs
ceilis85413743ce_ilis
ceils75019403ce_i_ls
celiacs11157893celiacs
cepes94424463ce__pes
ceps86125953ce__p_s
cerates95428253cerates
cercis104614493cer_cis
cercises12410933cercises
cercus105013153cer_cus
cereals9313173cereals
ceres75540013cer__es
cereus85215523cer_eus
ceria75125353ceri__a
ceric94023093ceri__c
cering94522533ceri_ng
cerise84822043ceri_se
cerite84724873ceri_te
cerium10313763ceri_um
cermets1139713cermets
ceros74726073cer__os
cerous85821203cer_ous
certes84623083cer_tes
ceruses93716233ceruses
cervices1537133cervices
cervixes2054603cervixes
cesiums1136303cesiums
ceviche1744143ceviche
ceviches1834843ceviches
cherish15310463cherish_
cherishes1767563cherishes
chips125721253c_hip_s
chirps135414003chirp_s
chrisms1499143chrisms
clerics1149333cleri_cs
clerids1049093cleri_ds
clips96018303c_lip_s
corps95927043cor_p_s
corpus106015293cor_pus
crapes104727693c_rapes
craps95328643c_rap_s
creeps104213623creep_s
crepes105419343c_repes
cribs94516753c_ri_bs
cricks144316053c_ricks
criers83918583c_riers
cries75438403c_ri_es
crimes105521583c_rimes
crimps124613453c_rimps
cripe95521143c_rip_e
cris66233433c_ri__s
crises84529433c_rises
crisis83716343c_risis
crisps104411513c_risps
crits75527573c_ri_ts
crops96125233c_rop_s
crwths1433433c_rwths
crypts13397743c_rypts
curaghs1334583curaghs
curies84934023curi_es
curios83218333curi_os
curious93813563curious
curites93919863curites
curiums1138503curiums
derides93420853derides
derives114017813derives
drips85417233_drip_s
ericas8315463_ericas
erupts8348903_erupts
euripus934623euripus
ferias95020393feri_as
friths124313583_friths
genips9469943genip_s
gerahs1039413ger_ahs
graphs124510153_graphs
gripes94619873_gripes
grips85520133_grip_s
griths105211653_griths
heriots10312063heriots
herpes115517323her_pes
jerids142810943jeri_ds
kaliphs1634293kaliphs
megilphs1641613megilphs
merinos9311983merinos
merises93421423merises
merisis93213173merisis
merits8320873meri_ts
morphs13149433mor_phs
neighs10387733ne_ighs
paraphs1439313paraphs
pariahs123812343pariahs
periapts1237273periapts
perils84121853peri_ls
periods10312243periods
peris75537073peri__s
perish114619063perish_
perishes13313753perishes
peritus9311803peritus
perps95521483per_p_s
recipes113314463recipes
redips93713843redip_s
rerigs74014793reri_gs
rerises73525883rerises
ripes75435773__ripes
rips66237433__rip_s
scarphs14437413scar_phs
scrips105316033scrip_s
scripts11509373scripts
serapes95218103serapes
seraph114011163seraph_
serials73919743serials
series64540973seri_es
serifs94017053seri_fs
serines74229543serines
serins64029673seri_ns
serious73616283serious
stripes95320573stripes
strips85719653strip_s
teraph11319093teraph_
thrips11299013thrip_s
tripes85324873_tripes
tripos84014923_tripos
trips74923363_trip_s
unrips8199453unrip_s
verisms123011253verisms
verists103613673verists
veritas103012753veritas
verites103822263verites
weighs13338873we_ighs
zeniths1935153zeniths

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 Filter1786911340270.530337152.8
2DLD Change Limit1340271577.54617761.3
3Display Results1571570.0632492.1
 (SQL Overall)1786911578.13921954.9
 
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.