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

125 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
climes10472000(None) 
chimes134922571chimes
climbs12498721climbs
clime95720891clime_
clines84926041clines
crimes105521581crimes
glimes94717521glimes
limes75636501_limes
slimes84722041slimes
alines65735222alines
almes75126542al_mes
animes84719592animes
blames105121862blames
blimey13468452blimey
blimps12588152blimps
blites84721212blites
blumes105917792blumes
calices114321692calices
cames97047312c_ames
chides124620472chides
chiles115425302chiles
chimbs153910302chimbs
chime125322592chime_
chimed145814832chimed
chimer135517202chimer
chimers144515132chimers
chimps155713662chimps
chines115029172chines
chives144317592chives
chymes165912152chymes
cilices113814022cilices
cimex16119132c_imex
cines75239682c_ines
cires74932912c_ires
cites74435582c_ites
clades94920462clades
claimed12298832claimed
claimer11279882claimer
claimers12298742claimers
claims105211572claim_s
clamps124515082clamps
clams95127672clam_s
claves115020062claves
cleomes1138812cleomes
clepes104214622clepes
cliches144213742cliches
clicks145315112clicks
cliffs14477592cliffs
clifts11519152clifts
climates12311962climates
climax1735652climax
climaxes1944612climaxes
climb115413592clim_b
climbed14336982climbed
climber13449132climber
climbers14318402climbers
cline76428532cline_
clings95716212clings
clinks125815062clinks
clips96018302cli_ps
cliques18309202cliques
clivers123411752clivers
clomps125212232clomps
clones84526562clones
closes85425592closes
cloves114918822cloves
clozes174915562clozes
clues74623032cl_ues
clumps1215314642clumps
colies84837052coli_es
comes97246992c_omes
cremes104517992cremes
cries75438402cri_es
crime94822692crime_
crimps124613452crimps
cripes105120872cripes
crises84529432crises
culices113713122culices
cylices14359282cylices
cymes1210118922c_ymes
delimes10314192delimes
dimes85833042_dimes
elides74420692elides
elites66027122elites
flames114723692flames
flies85630712fli_es
flites95122442flites
flumes115119732flumes
glides84518862glides
glime85620192glime_
glimed105312282glimed
glims87417672glim_s
glumes94516812glumes
grimes94619032grimes
lames75445542_lames
lies46454192_li_es
likes96231902_likes
limas75627632_limas
limbs96118942_limbs
lime66244932_lime_
limed85426802_limed
limen75426032_limen
limens84618032_limens
limey104721042_limey
limeys11429272_limeys
limns75718392_limns
limos75320812_limos
limps95522672_limps
lines57054572_lines
lives86133192_lives
mimes95732022_mimes
olives94313952olives
oximes15107422oximes
plies74526512pli_es
plumes104318132plumes
primes104225262primes
rimes75634542_rimes
slices84022852slices
slides73922182slides
slime74925752slime_
slimed94915122slimed
slims75423652slim_s
slipes84921412slipes
stimes85920572stimes
times75630822_times

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.1101624463.6
2DLD Change Limit825511252.68630733.8
3Display Results1251250.0333787.9
 (SQL Overall)1786911252.82963164.0
 
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.