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

126 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
cithren1230659(None) 
cithern12489911cithern
cithrens13355931cithrens
cither114616682cith_er
citherns13338862citherns
cithers124315752cithers
citizen1845712citizen
citrin82615402cit_rin
citron83112982cit_ron
cittern9339132cittern
zithern19447022zithern
bitchen14349733bitchen
bitten84715123bit_ten
bittern94810683bittern
bitumen1134503bitumen
brethren1343783brethren
cateran9313763cateran
catered103117763catered
caterer92815933caterer
children1474703children
chirren12388743chirren
cicoree1149843cicoree
cigaret10412993cigaret
cinerin9313823cinerin
cipher133710263ciph_er
ciphered1637053ciphered
cipherer1545573cipherer
ciphers14379983ciphers
cire65836373ci__re_
cires74932913ci__res
cistern93310693cister_n
cistron9299883cistron
citadel1044373citadel
cite65640343cit__e_
cited84421953cit__ed
citer74827323cit__er
citers85022973citer_s
cites74435583cit__es
cithara12166493cithara
citharas13156703citharas
citied94014143cit_ied
cities84524853cit_ies
citizens1943983citizens
citole8311503citole_
citoles9312553citoles
citral81113883cit_ral
citric102812303cit_ric
citrine92514023cit_rine
citrins92614363cit_rins
citrons92913223cit_rons
citrus83610913cit_rus
citterns10318113citterns
cothurn1245033cothurn
dither104417683dith_er
dithered13189293dithered
ditherer12187763ditherer
dithers114016153dithers
dithery14318943dithery
either94517423eith_er
gittern8337503gittern
hither124417253hith_er
hitmen11239193hit_men
ither84617603_ith_er
kitchen16287683kitchen
kithe125917453kith_e_
kithed144613013kith_ed
kithes135016653kith_es
kitten104611483kit_ten
lichen114012743lich_en
lighten112811523lighten
lithe84922013lith_e_
lither94520953lith_er
lithoed1137833lithoed
litre55421463lit_re_
litres65220393lit_res
litten64014873lit_ten
luthern1037653luthern
misthrew16124763misthrew
mitered103213233mitered
miterer92511333miterer
mither114218563mith_er
mithers123516733mithers
mitogen1036963mitogen
mitre75522423mit_re_
mitred94414343mit_red
mitres83922073mit_res
mitten83914093mit_ten
nitre57519683nit_re_
nitres65519333nit_res
pitchmen1744333pitchmen
pithed124615613pith_ed
pithier123010293pithier
pitmen102510793pit_men
potheen12257893potheen
richen113812513rich_en
siren54525823si__ren
sithens1039383sith_ens
sitten64113823sit_ten
then78429693__th_en
three87526913__three
threw1117315713__threw
tighten11288973tighten
tithe85319703tith_e_
tithed104115593tith_ed
tither94920283tith_er
tithers104216733tithers
tithes94720213tith_es
titmen8239883tit_men
titre54619393tit_re_
titres64718933tit_res
upthrew1542663upthrew
withdrew1842473withdrew
withe115220233with_e_
withed134416233with_ed
wither124321353with_er
withered15169433withered
witherer14187953witherer
withers134417753withers
withes124620843with_es
withier132910493withier
withies133913543withies
within123611383with_in
writhen13407863writh_en
zither183813083zith_er
zitherns20376133zitherns
zithers193911973zithers

Search took 7 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.1701051123.5
2DLD Change Limit1340271266.66020124.2
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.87625987.6
 
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.