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

100 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
ufologies134598(None) 
urologies1039531urologies
apologies12311192apologies
biologies12311182biologies
ecologies12312352ecologies
enologies10312982enologies
geologies11410642geologies
myologies1539752myologies
neologies10411712neologies
ologies8615022__ologies
oologies9312992_oologies
orologies10311622orologies
otologies10311402otologies
ufologist1347052ufologist
ufologists1445422ufologists
zoologies1939012zoologies
aerologies11312023aerologies
agrologies1237693agrologies
algologies1246793algologies
analogies101910643analogies
apiologies1339063apiologies
apologias1247503apologias
apologise1248303apologise
apologises1347303apologises
apologizes2246203apologizes
apologues1245023apologues
areologies1139823areologies
audiologies1345623audiologies
axiologies1837483axiologies
biologics1446863biologics
boogies103719013_bo_ogies
bryologies1646043bryologies
cetologies13410853cetologies
colognes11310603_colognes
colonies103620013_colonies
cytologies1639263cytologies
doxologies1946323doxologies
duologues1143393duologues
ethologies14310543ethologies
etiologies1139413etiologies
eulogies938523_eulogies
felonies11310993_felonies
fetologies1439183fetologies
floosies113210233_floosies
floozies20326953_floozies
fogies104118063_f__ogies
folkies143612253_fol_kies
follies103618943_fol_lies
foodies113416753_fo_odies
footies103721543_fo_oties
gemologies1449003gemologies
geologizes2146793geologizes
homologies16311523homologies
horologies14411053horologies
ideologies1237333ideologies
isologues1044563isologues
menologies13310603menologies
misologies13139063misologies
mixologies20136583mixologies
monologies13312543monologies
museologies1444543museologies
mycologies1848863mycologies
neologizes2047243neologizes
neurologies1248233neurologies
nomologies1339473nomologies
noogies82814583_no_ogies
nosologies1148103nosologies
oecologies1339463oecologies
oenologies1139393oenologies
oinologies1148303oinologies
oncologies1348653oncologies
ontologies1139883ontologies
pedologies1439343pedologies
penologies13311233penologies
pomologies15310043pomologies
posologies1349543posologies
prologizes2248113prologizes
prologues1246903prologues
pyrologies16310013pyrologies
rheologies1488433rheologies
serologies11311333serologies
sexologies1837713sexologies
sinologies1148893sinologies
sitologies1148703sitologies
tautologies1245913tautologies
theologies141010103theologies
tocologies1349763tocologies
tokologies1547143tokologies
topologies1348973topologies
trilogies1048173trilogies
typologies1647643typologies
ufological1644903ufological
ufology14244563ufolog__y
uranologies1246133uranologies
urologic1147343urologi_c
urologist10411053urologist
urologists1148413urologists
venologies1438373venologies
virologies1447213virologies
zymologies2546413zymologies

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411007.11020905.9
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.57923577.1
 
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.