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

190 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
cineast931052(None) 
cineaste1045741cineaste
cineasts1045541cineasts
cineastes1165562cineastes
cinemas1138042cinemas_
cines75239682cine_s_
finest94321732fine_st
tineas64616482tineas_
abreast9311283abreast
airest63825263aire_st
anenst63514983_anenst
apneas83211383apneas_
beast76338643__beast
biners85023633biners_
bines76946793bine_s_
breast8319633_breast
canasta938363can_asta
caners84629203caners_
canes75350373cane_s_
cannas84518403cannas_
canoeist10310693canoeist
canst74932213can__st
canvas113813333canvas_
canvass12376873canvass
casease939323casease
cast67159903c___ast
caveat11417723cavea_t
caveats1239803caveats
cease75227653c__ease
centas85020703centas_
cheat105732453c_hea_t
cheats114519543c_heats
chest104926143c_he_st
chicest14209943chice_st
chiliast13117933chiliast
chinas115119403chin_as_
chines115029173chine_s_
ciders94620093ciders_
cinders104617763cinders_
cine66242943cine___
cinema1047653cine_ma
cineol8108203cine_ol
cineole91010003cineole
cineols9128853cineols
cinerary1346433cinerary
cinerin9313823cinerin
cires74932913cire_s_
cist67244963ci___st
citers85022983citers_
cites74435593cite_s_
civet105828733cive__t
civets115212543civets_
clast76030583c__last
cleat76335063c_lea_t
cleats84919313c_leats
clines84926043cline_s_
coast75236273c__oast
coenact11311803coenact
coiners93620753coiners_
cones76457423cone_s_
coneys115218423coneys_
congas94417033congas_
congest104618773congest
consist9316033consist
contact1144020683contact
contest93523233contest
contrast102614783contrast
corneas94717003corneas_
coyest11316053coye_st
crease85519573c_rease
creasy114612303c_reasy
crest74632693c_re_st
cuneal8611513cunea_l
cuneate9311723cuneate
cutest85820143cute_st
dicast9315573di_cast
digest84019623dige_st
diners75525953diners_
dines66449153dine_s_
direst75024243dire_st
disease83213843disease
dismast10311233dismast
divest106820073dive_st
dynast1088223dyn_ast
east46659103___east
faineant1146743faineant
fainest10417703faine_st
fantast10311703fantast
feast85932723__feast
fideist1139753fideist
fincas113512073fincas_
fines86644263fine_s_
finesse10187643finesse
funest94316863fune_st
guineas836753guineas_
honest94822423hone_st
iciest82914743icie_st
iciness938863icine_ss
ideas65919013_ideas_
inapt73522693_in_apt
incant82418513_incant
incase83615283_incase
incest82918743_incest
inearth1037043_inearth
inept73622153_ine_pt
inert53234373_ine_rt
inerts64517023_inerts
inexact1647413_inexact
infant92315133_infant
infest93315433_infest
ingest73119003_ingest
inmost8411363_inmost
insist6314513_insist
intact8314663_intact
invest93014843_invest
jiveass1792163jiveass
kinas95626913kin_as_
kinase104210653kin_ase
kindest12311503kindest
kinemas1336893kinemas_
kines95039133kine_s_
least56134883__least
likest104914383like_st
lineage878983lineage
lineal65616033linea_l
linear65113343linea_r
lineate7815153lineate
linecut997983linecut
linens64818393linens_
liners65428853liners_
lines57054573line_s_
lingas75116573lingas_
liniest73321153liniest
livest95315733live_st
mainmast1245883mainmast
minas75434113min_as_
miners84126633miners_
mines75651953mine_s_
miscast11312423miscast
misease92713043misease
miseat82925713misea_t
miseats92815793miseats
neat46356783__nea_t
neats55931903__neats
neist54628443__neist
nest45548733__ne_st
nicest82315663nice_st
nines55937343nine_s_
ninjas1386303ninjas_
nonpast939033nonpast
pinas75434453pin_as_
pineal84817693pinea_l
pineals93212853pineals
pines76048863pine_s_
pinesap1164723pinesap
piniest93121133piniest
pinkest132812623pinkest
pinnas85315513pinnas_
pintas85021393pintas_
renest64529713rene_st
rifest93114583rife_st
ripest84317943ripe_st
sanest64426693sane_st
sines55954823sine_s_
sinews94210623sinews_
sunfast1038503sunfast
tinea54923163tinea__
tineal66216173tinea_l
tines54848423tine_s_
tiniest73020123tiniest
uncast84215713_uncast
unease63816643_unease
uneasy9278853_uneasy
usneas638333usneas_
vainest10315763vaine_st
vilest9416843vile_st
vinas85126343vin_as_
vincas113912453vincas_
vineal94814753vinea_l
vines85137643vine_s_
viniest103216613viniest
widest104517003wide_st
wines85546863wine_s_
winesap1264443winesap
winiest103419693winiest
wiseass1035823wiseass
wisest95016443wise_st
yeast85327943__yeast
zinebs17606803zinebs_
zines145232653zine_s_

Search took 8 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.420425454.8
2DLD Change Limit1340271906.89319443.9
3Display Results1901900.0633015.9
 (SQL Overall)1786911907.37624226.0
 
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.