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

171 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
ocelli83684(None) 
celli76717691_celli
ceili75814792_ceili
cell65031722_cell_
cella75420312_cella
cello74919582_cello
cells75428062_cells
duelli767002duelli
nielli636302nielli
nucelli944722nucelli
obeli73711932obe_li
ocellar936532ocellar
ocellus935982ocellus
oceloid1037962oceloid
ocelot8813382ocelot
oculi72010792oc_uli
aculei839793aculei
bacilli1146393bacilli
bell66237183_bell_
belle75827833_belle
bells76432163_bells
belly104625493_belly
call66838673_call_
calla74827073_calla
calls75634733_calls
cedi74919273_ce_di
ceil65725063_ceil_
ceilis85413743_ceilis
ceils75019403_ceils
cel56040553_ce_l_
celeb9314873_celeb
cellae84915933_cellae
cellar84514983_cellar
celled94420323_celled
celling103921263_celling
cellist9314423_cellist
cellos84517803_cellos
celom9515683_celom
cels65534973_ce_ls
celt65646713_ce_lt
celts75325783_celts
cerci93716393_cerci
cesti75217423_cesti
chili106218483_chili
chilli114312773chilli
coelom10310423coelom
collie83621993_collie
colly104926773_colly
coolly114811393coolly
cull65929643_cull_
cullis84115993_cullis
culls75425813_culls
cully105520463_cully
culti76317253_culti
deli55631293_de_li
dell56938203_dell_
dells66630943_dells
delly96023873_delly
duello756783duello
dwell9519853dwell_
dwells10417713dwells
echelle1246623echelle
elhi7612403__elhi
ell36735683__ell_
ells46431353__ells
fell76833073_fell_
fella84918653_fella
fells85327383_fells
felly114922803_felly
focally15188553focally
hell75637893_hell_
hello86522983_hello
hells85032043_hells
jell117125873_jell_
jello126716273_jello
jells125522163_jells
jelly154218253_jelly
kelly124617023_kelly
knell94210923knell_
knells10439253knells
kvell12436693kvell_
kvells13346613kvells
locally12179723locally
loculi8288253loc_uli
mell64935613_mell_
mells75031333_mells
micell1098193micell_
micella11106823micella
micelle1178343micelle
micells11107683micells
monellin1047373monellin
morelle91210803morelle
morello9117793morello
muesli835183muesli
nacelle938153nacelle
nellie63614813_nellie
nelly84618813_nelly
niello636603niello
novella1076213novella
novelle1058233novelle
novelly1346513novelly
obelia8329453obelia
obelus8348403obelus
oboli73712873o_boli
occult1038433occult
ocean71212963oce_an
oceanic1146163oceanic
oceans81211003oceans
ocellate1037863ocellate
ocelots977233ocelots
octal71214723octal_
octopi1036533octopi
octroi837363octroi
octyl10136063octyl_
octyls11135323octyls
ocular8610133ocular
oculus8178393oculus
olla44821173o__lla
omelet8317073omelet
oorali6311263oorali
openly1137123openly
orally93113593orally
ovally12278443ovally
overlie102615013overlie
overlit102714743overlit
overly122411363overly
ovoli8358283o_voli
paella8410913paella
phalli1148263phalli
quell144311423quell_
quells15359693quells
roselle7310243roselle
scall74420373scall_
scalls84218203scalls
scilla8310943scilla
scull75315763scull_
sculls84613883sculls
sell45840613_sell_
selle54428313_selle
sells55134433_sells
shell84424123shell_
shells94319523shells
shelly124414463shelly
skell94915833skell_
skells105013783skells
smell74916233smell_
smells83914743smells
smelly114110353smelly
snell54517303snell_
snells64614203snells
spell75020303spell_
spells84617683spells
stelai63912563stelai
stella63612973stella
swell84815983swell_
swells93913983swells
tell44934703_tell_
tells55828943_tells
telly84920823_telly
teloi54217383_teloi
teocalli1044373teocalli
thalli958913thalli
trellis739873trellis
villi86517853_villi
vocally15188343vocally
well75832043_well_
wellie92814913_wellie
wells85426193_wells
welly114620013_welly
yell76028323_yell_
yells85821943_yells

Search took 9 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161718.43613361.3
3Display Results1711710.0463717.4
 (SQL Overall)1786911718.62220725.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.