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 “apologists” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
apologists134888(None) 
apologises1347301apologises
apologist12412401apologist_
algologists1346142algologists
analogists1147312analogists
apologias1247502apologi_as
apologies12311192apologi_es
apologise1248302apologis_e
apologised1444322apologised
apologizes2246202apologizes
biologists1349432biologists
ecologists13310922ecologists
enologists11310622enologists
geologists1279162geologists
myologists1648202myologists
neologists1139772neologists
ologists939442__ologists
oologists1039852_oologists
orologists1149822orologists
otologists1149632otologists
poloists10910522_polo_ists
prologists13311172prologists
topologists1447862topologists
typologists1746812typologists
ufologists1445422ufologists
urologists1148412urologists
zoologists2047172zoologists
algologist1248243algologist_
analogisms1345213analogisms
analogist10410233analogist_
anthologists1648033anthologists
aphorists1448263ap_horists
apiologies1339063apiologi_es
apologia1147723apologi__a
apologiae1245763apologi_ae
apologising1583633apologising
apologize2146123apologi_ze
apologized2354833apologized
apologizer2244343apologizer
apologizers2342823apologizers
apologs1038593apolog___s
apologues1245023apolog_ues
audiologists1445613audiologists
biologisms1545343biologisms
biologist12412343biologist_
bryologists1745703bryologists
cetologists1449163cetologists
colonists112512503_colonists
colorists112313593_colorists
cytologists1748013cytologists
dialogists1265603dialogists
ecologist12314143ecologist_
enologist10314123enologist_
escapologists1853343escapologists
ethologists1549023ethologists
eulogists1046653_eulogists
fetologists1547993fetologists
gemologists1577883gemologists
geologist11611783geologist_
graphologists20123833graphologists
horologists1548963horologists
ideologists1346653ideologists
mixologists2145683mixologists
monologists14410073monologists
mycologists1947733mycologists
myologist15411093myologist_
neologisms1345483neologisms
neologist10712813neologist_
ologist8313833__ologist_
oncologists1448073oncologists
ontologists1248903ontologists
oologist9313493_oologist_
orologist10313103orologist_
otologist10412813otologist_
papyrologists2154083papyrologists
pathologists1848373pathologists
pedologists1548273pedologists
penologists1449593penologists
polemists1348603_polemists
pollists10910823_pol_lists
poloist91016323_polo_ist_
pomologists1648983pomologists
prologist12315083prologist_
radiologists1497363radiologists
rheologists1547313rheologists
serologists12410123serologists
sexologists1947253sexologists
sinologists1257673sinologists
soloists869153_solo_ists
syllogists14175173syllogists
topologist13410643topologist_
typologist1648893typologist_
ufologist1347053ufologist_
urologist10411053urologist_
virologists1546633virologists
zoologist1949693zoologist_

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 Filter1786911406030.406440125.6
2DLD Change Limit140603966.39022003.6
3Display Results96960.0501920.0
 (SQL Overall)178691966.84626101.5
 
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.