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 “crises” with Change Limit: [1] [2]

(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
crises8452943(None) 
arises65233801arises
brises84927611brises
cerises94722251cerises
crases85532311crases
cries75438401cri_es
crimes105521581crimes
cripes105120871cripes
crisis83716341crisis
crisps104411511crisps
cruises93514441cruises
cruses88127711cruses
frises94124271frises
irises64221171irises
krises105016081krises
prises84133171prises
rises55244041_rises
anises64826692anises
arise56436432arise_
arisen65316792arisen
arrises71617582arrises
arses55733872ar_ses
axises134413992axises
birses84717732birses
bises75435622_bises
braises93818872braises
bribes105918532bribes
brides94423512brides
bries74942152bri_es
brines85028852brines
brisks124611402brisks
briss75824272bris_s
brisses94314312brisses
broses86524402broses
bruises93212912bruises
camises114218462camises
caribes113715642caribes
carices114220952carices
caries85147622cari_es
carses85233652carses
cases75048382c_ases
causes88026472causes
ceases84427072ceases
censes83721802censes
cercises12410932cercises
cerise84822042cerise_
cerites94823432cerites
ceruses93716232ceruses
cesses84221362cesses
chaises124317492chaises
chases115128232chases
chides124620472chides
chiles115425302chiles
chimes134922572chimes
chines115029172chines
chisel112111942chisel
chisels12219102chisels
chives144317592chives
choses115825132choses
chrisms1499142chrisms
cines75239682c_ines
cires74932912c_ires
cists76624532c_ists
cites74435592c_ites
climes104720002climes
clines84926042clines
closes85425592closes
copses104922472copses
corpses113913802corpses
corses84433462corses
coses76949492c_oses
cosies84932152cosies
crakes124921812crakes
cranes84330752cranes
crapes104727692crapes
crashes124618402crashes
crasis85020472crasis
crass76328042cras_s
crates85736062crates
craves115825392craves
crazes174720132crazes
creases94020962creases
creeses93914622creeses
cremes104517992cremes
crepes105419342crepes
cress75022832cres_s
cresses94219812cresses
crests85218702crests
cribs94516752cri_bs
cricks144316052cricks
cried84624282cri_ed
crier74724462cri_er
criers83918582criers
crikey15317782crikey
crime94822692crime_
crimps124613452crimps
cringes103215502cringes
cripe95521142cripe_
cris66233432cri__s
crisic103611842crisic
crisp95014622cris_p
crisped124010102crisped
crispen11348202crispen
crispens12286252crispens
crisper113511052crisper
crispers12309432crispers
crispest12177372crispest
crispy13478562crispy
crissa837622crissa
crista8311802crista
crits75527572cri_ts
crones84729242crones
crores86121162crores
cross75124502cros_s
crosse85216302crosse
crosses94220792crosses
crozes174417662crozes
cruces105117542cruces
crudes96218622crudes
cruise84314042cruise_
cruised103710212cruised
cruiser93410432cruiser
cruisers10438272cruisers
cruse75726102cruse_
cruset84425092cruset
crusets93811042crusets
crushes124215132crushes
crusts84916542crusts
cruxes154911562cruxes
cuishes122810822cuishes
cuisse8318332cuisse
cuisses9319882cuisses
curies84934022curi_es
curites93919862curites
curses85328272curses
cusses84522772cusses
cutises94414912cutises
cyeses11510122cyeses
daises74318982daises
dries64733672dri_es
drives105117112drives
druses75517252druses
egises7312492egises
erases64425402erases
eroses65327052eroses
erses55826802er_ses
fraises104215692fraises
fries85535602fri_es
friges104116482friges
frise85322452frise_
frisee94217992frisee
frisees104411692frisees
frisks13479262frisks
frites94922482frites
frizes184015462frizes
grides84422362grides
grilses8319152grilses
grimes94619032grimes
gripes94619872gripes
grists74716482grists
guises74216312guises
hoises94823672hoises
ibises83610542ibises
irides74519122irides
irised73913152irised
lorises73918592lorises
merises93421422merises
mises74740562_mises
noises65021852noises
orrises71312232orrises
parises94827182parises
peises84125042peises
poises84226542poises
praises94121102praises
prases84429022prases
prices104524542prices
prides94324182prides
pries74339532pri_es
primes104225262primes
prise74632612prise_
prised94322202prised
prisms104915502prisms
priss74623892pris_s
prisses94816712prisses
prizes173819812prizes
proses84733472proses
raises64826542raises
rases55447212_rases
rerises73525882rerises
ribes75530172_ribes
rices75536152_rices
rides66140812_rides
riles55343642_riles
rimes75634542_rimes
rinses64720382_rinses
ripes75435772_ripes
rise45945232_rise_
risen54621882_risen
riser55431052_riser
risers64624782_risers
risks94917062_risks
risus54216392_risus
rites54442552_rites
rives85336002_rives
roses56445772_roses
ruses56136582_ruses
scribes113713202scribes
scries85226822scri_es
scrives124414272scrives
seises64026712seises
sises55233832_sises
tribes85119022tribes
trices84826332trices
tries55742812tri_es
trikes105419492trikes
trines64132562trines
trioses75015652trioses
tripes85324872tripes
uprises92012732uprises
urases63723562urases
urines64724122urines
uruses63616502uruses
vises84427772_vises
wises85633192_wises
wries85827742wri_es
wrists95415642wrists
writes94420332writes

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825512272.25036689.3
3Display Results2272270.0932440.9
 (SQL Overall)1786912272.68666526.8
 
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.