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

132 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
cremes10451799(None) 
creme94319321creme_
crepes105419341crepes
crimes105521581crimes
arames84622572arames
arenes64928392arenes
aretes64425352aretes
bermes106023002bermes
biremes1138772biremes
bredes94818472bredes
brees75632552bre_es
breves115516422breves
bromes104719762bromes
brumes106417072brumes
cames97047312c_ames
cedes84927322c_edes
cees65941592c_e_es
cepes94424462c_epes
ceres75540012c_eres
cermet10321152cermet
cermets1139712cermets
certes84623082certes
cetes75731102c_etes
chemos13311722chemos
chimes134922572chimes
chromes142914932chromes
chymes165912152chymes
cleomes1138812cleomes
clepes104214622clepes
climes104720002climes
comes97246992c_omes
crakes124921812crakes
crambes1339952crambes
cramps125615562cramps
crams96229152cram_s
cranes84330752cranes
crapes104727692crapes
crases85532312crases
crates85736052crates
craves115825392craves
crazes174720132crazes
creaks124315962creaks
creamed123913712creamed
creamer113714082creamer
creamers124111292creamers
creams104715252creams
crease85519572crease
creases94020962creases
creates95225172creates
creches14313092creches
credos94612842credos
creds85418772cre_ds
creed85727392cre_ed
creeds94714772creeds
creek114917392cre_ek
creeks124812922creeks
creel75121482cre_el
creels84416942creels
creep95218102cre_ep
creeps104213622creeps
creese84014332cre_ese
creeses93914622creeses
creesh11328332cre_esh
cremates124215982cremates
crenel84213062crenel
crenels93711012crenels
creoles9913322creoles
crepe95520722crepe_
creped114115702creped
crepey135110932crepey
cress75022832cre_ss
cresses94219812cresses
crests85218702crests
crewed125316552crewed
crewel114310472crewel
crewels12438482crewels
crewmen1436372crewmen
crews105917492cre_ws
cries75438402cr_ies
crime94822692crime_
crimps124613452crimps
cripes105120872cripes
crises84529432crises
crones84729242crones
crores86121162crores
crozes174417662crozes
cruces105117542cruces
crudes96218622crudes
crumbs12409232crumbs
crumps124514342crumps
cruses88127712cruses
cruxes154911562cruxes
cyeses11510122cyeses
cymes1210118922c_ymes
demes86032692_demes
drees65628522dre_es
emes65434662__emes
femes105626222_femes
frames115119862frames
frees86131392fre_es
freres94716172freres
grebes93813612grebes
grees65132472gre_es
grimes94619032grimes
grumes94415552grumes
hemes105031082_hemes
kermes124616122kermes
krewes1337922krewes
memes94927702_memes
prees75937172pre_es
premed114617752premed
premeds12389582premeds
premen105017802premen
premies113823062premies
prexes154915942prexes
prezes173614692prezes
primes104225262primes
redes65139122_redes
rees45364192_re_es
reges65628782_reges
remet74843722_remet
remex146315792_remex
rems66237722_rem_s
rexes124526952_rexes
rhemes115913182rhemes
rimes75634542_rimes
schemes1489662schemes
screes85023962scre_es
semes75731582_semes
themes115319252themes
trees55835762tre_es
vermes115019142vermes

Search took 4 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.1231452772.4
2DLD Change Limit825511322.83029170.0
3Display Results1321320.0462869.6
 (SQL Overall)1786911322.99959583.5
 
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.