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

159 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
epinaos93628(None) 
epinaoi945001epinaoi
eringos836912eringos
pepinos1137692pepin_os
pianos84315932_pianos
pinas75434452_pina_s
pingos95317672_pingos
pinkos125313872_pinkos
pintos86021292_pintos
spinals93911862spinals
spintos939132spintos
apicals1159923apicals
bingos95514793_bingos
chinas115119383china_s
chinos115018693chin_os
dinars75417563_dinars
dinos65428063_din_os
eidos65817753e_i_dos
elints65816423elin_ts
encinas938723encina_s
ephahs1435503ep_hahs
ephas10311543ep_ha_s
ephebos1444113ephebos
epical10413393epica_l
epicarp1376073epicarp
epicarps1444783epicarps
epics95014283epi__cs
epigeous1146533epigeous
epigon937963epi_gon
epigons1048183epigons
epigrams1346113epigrams
epilate9314283epilate
epilates10313503epilates
epilator1049243epilator
epilators1149423epilators
epilog976463epi_log
epilogs1076583epilogs
epimers11109493epimers
epinasty1343133epinasty
epitaph1444133epitaph
epitaphs1543233epitaphs
epitases1038933epitases
epitasis1047433epitasis
epitaxy1963563epitaxy
epizoa1745013epi_zoa
epizoon1843813epizoon
eponyms1444853eponyms
epos66723733ep___os
ericas8315463erica_s
eringo739553eringo_
eringoes937433eringoes
eryngos1142733eryngos
espials937093espi_als
ethnos947053ethn_os
etnas54713933e_tna_s
evinces1237803evinces
exines135715803exin_es
finals94316163_finals
finos86226953_fin_os
gringos936673gringos
infos84311673__infos
kinas95626913_kina_s
kinos96626143_kin_os
linacs8310813_linacs
linos55631503_lin_os
medinas103411463medina_s
merinos9311973merin_os
minas75434113_mina_s
naos47429733___naos
olingos846013olingos
opines84820703opin_es
opinion946793opinion
opinions1045933opinions
pantos85222743_pantos
peins76128063pein__s
pengos94612413_pengos
pepino10310333pepin_o_
petnaps1145033petnaps
piano76118713_piano_
pians75126963_pi_ans
pias66542553_pi_a_s
pibals103813083_pibals
picaros11310893_picaros
picas94626523_pica_s
pikas114218093_pika_s
pilafs113511023_pilafs
pilaus84114133_pilaus
pilaws11399433_pilaws
pimas94725103_pima_s
pina65842633_pina__
pinang92611593_pinang
pinangs10267793_pinangs
pinata83817213_pinata
pinatas93711483_pinatas
pineals93212843_pineals
pines76048863_pin_es
pingo87122713_pingo_
pingoes105116513_pingoes
pings85830883_pin_gs
pinion83815893_pinion
pinions93413603_pinions
pinko115618253_pinko_
pinkoes135512313_pinkoes
pinks115729383_pin_ks
pinnas85315513_pinnas
pinon76024533_pin_on
pinons86019943_pinons
pinot78737293_pin_ot
pinots85920273_pinots
pins65558453_pin__s
pintados11105993_pintados
pintanos10107553_pintanos
pintas85021393_pintas
pinto75625753_pinto_
pintoes95117713_pintoes
pints75936223_pin_ts
pinups1037413_pinups
pinyon11459763_pinyon
pinyons12299003_pinyons
pipals104213643_pipals
piscos105112593_piscos
pisos76021063_pi_sos
pitas77427673_pita_s
praos74923563_p_raos
punas74826753_puna_s
puntos85915793_puntos
quinoas16337873quinoas
reginas85614063regina_s
repiners103913433repiners
repines94927383repin_es
repins84924313repin__s
retinals85612963retinals
retinas74819353retina_s
rhinos94411123rhin_os
seminars1079043seminars
sepias83616103sepi_a_s
spicas104715823spica_s
spinach1435393spinach
spinage10289653spinage
spinages11289293spinages
spinal84915313spina_l
spinate93114813spinate
spinels94512443spinels
spines85132033spin_es
spinets94714813spinets
spinor839943spin_or
spinors939413spinors
spinose937943spin_ose
spinous9310443spinous
spins75327983spin__s
spinto8410663spinto_
spirals93212513spirals
spitals93011593spitals
stingos8459443stingos
urinals7610253urinals
vinals94716483_vinals
vinas85126343_vina_s
vinos84723073_vin_os
winos84625043_win_os

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.1401276364.3
2DLD Change Limit1340271596.76619808.9
3Display Results1591590.0463456.5
 (SQL Overall)1786911596.95225703.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.