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

176 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
isolog73740(None) 
isologs837431isologs
apolog938902apolog
colog86619932_colog
duolog835802duolog
isogon7227542isogon
isologue944612isologue
isopod935912isopod
misology1447132misology
prolog94212972prolog
slog56728272_s_log
solo45538942_solo_
solon55026132_solon
solos54830792_solos
analog7159973analog
apologs1038593apologs
apology1337913apology
beclog1136863beclog
bicolor1145613bicolor
biology1337363biology
blog75723823__blog
bolo65535953_bolo_
bolos75531373_bolos
cholo105217973cholo_
cholos114716853cholos
clog76123243__clog
cohog117813043_cohog
cologs96517353_cologs
colon78630193_colon
color76123743_color
dialog837973dialog
discolor1146423discolor
dolor67617963_dolor
duologs935363duologs
ecology13218823ecology
eidolon844913eidolon
enology11239813enology
epilog976463epilog
flog85523893__flog
geology12257323geology
gigolo836533gigolo_
gigolos934693gigolos
histology1645653histology
homolog1346963homolog
ideology1345653ideology
idol56818633idol__
idols65514133idol_s
igloo6410493i_gloo
igloos738033igloos
incog838253i_ncog
inflow1235293inflow
insole63515863insol_e
insoles73516243insoles
iroko939663iroko_
irokos1037233irokos
isagoge943933isagoge
isle45121703is_l_e
isled64615993is_led
isles54220563is_les
islet54527553is_let
isling71213883isling
isobar836143isobar
isochor1244743isochor
isodose845373isodose
isoform1244963isoform
isogloss943363isogloss
isogone8237913isogone
isogons8217613isogons
isogony11215453isogony
isohel935483isohel
isolate7313923isolate
isolator847533isolator
isolead835183isolead
isoline7314013isoline
isologous1043223isologous
isologues1044563isologues
isomer8310153isomer
isonomy1245263isonomy
isopods1045573isopods
isotone7239983isotone
isotope9227783isotope
isotopy12215123isotopy
istle52214713istl_e
istles62814983istles
kolo87026223_kolo_
kolos94921213_kolos
log46252683___log
miscolor1245603miscolor
mixology2144833mixology
monolog10259353monolog
myology1636163myology
neology11238293neology
nolo46229313_nolo_
nolos54423353_nolos
nosology1246143nosology
oinology12196703oinology
ology94113113__ology
oology103210253_oology
oolong738073_oolong
orology11319463orology
otology11308753otology
ovolo8339173ovolo_
ovolos9257203ovolos
photog12379813photog
polo66236633_polo_
polos76129913_polos
posology1447243posology
proleg94612113proleg
prologs103512133prologs
prolong10319633prolong
putlog965553putlog
quohog1942503quohog
salol55222143_salol
salon55228553_salon
sawlog1035793sawlog
shog86025143_s_hog
sholom11910113sholom
sigloi737743sigloi
siglos7311473siglos
silo46037913_silo_
silos56029433_silos
sinology12247183sinology
sitology12256623sitology
slag55934353_s_lag
slob66029423_s_lob
sloe45534953_s_loe
slogs64521843_s_logs
sloop76118913_sloop
slop66533873_s_lop
slot46049833_s_lot
slow77729493_s_low
slug55124643_s_lug
smog76317413_s_mog
snog55623633_s_nog
sodom8814913_sodom
sokol94612293_sokol
sol37256623_sol__
sola45541863_sol_a
solan55328153_solan
solar55927343_solar
sold54837413_sol_d
soldi65717203_soldi
soldo67116563_soldo
sole46053673_sol_e
soled65835173_soled
solei55624343_solei
soles55547923_soles
soli46637013_sol_i
solid65025083_solid
soling74226823_soling
solion6616383_solion
soloed74515743_soloed
soloing82813803_soloing
solons65120023_solons
sols45448163_sol_s
solum74717613_solum
solus54726983_solus
solve85618943_solve
song55133673_so_ng
sook84933393_so_ok
soon46240503_so_on
soot45761063_so_ot
sopor74016493_sopor
sorgo64719723_sorgo
sotol54917653_sotol
stolon64112073stolon
theolog1146153theolog
tholoi9339233tholoi
tholos94213003tholos
timolol944113timolol
ufology14244563ufology
unclog956603unclog
urology11217583urology
virology1545843virology
weblog1234223weblog
zoology2036513zoology

Search took 6 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.390458182.1
2DLD Change Limit1127161765.08022188.2
3Display Results1761760.0602933.3
 (SQL Overall)1786911765.53032313.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.