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

68 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
otalgic104506(None) 
otalgia844481otalgia
antalgic1146702antalgic
coxalgic2043022coxalgic
italic839902ital_ic
myalgic15134222myalgic
nostalgic1253172nostalgic
otalgias944182otalgias
otalgies936392otalgies
otalgy1035352otalg_y
oxalic1537092oxal_ic
algid75415583__algid
algin65718763__algin
analgia898363analgia
analogic1148613analogic
antalgics1245173antalgics
atactic11410083atactic
atavic11189293ata_vic
ataxic15169203ata_xic
atelic8313703atel_ic
botanic1159583bota_nic
calcic9311873_calcic
catalogic1446683catalogic
cobaltic1455913cobaltic
coxalgia1842743coxalgia
dialogic1247453dialogic
gallic9411643_gallic
italics936993ital_ics
magic105818663_ma_gic
malic94525663_mal_ic
metallic1247643metallic
myalgia13124293myalgia
nostalgia1053183nostalgia
nostalgics1352283nostalgics
octadic1245713octa_dic
oleic7313333o__leic
ontologic1247783ontologic
oologic1049423oologic
orgic8311823o__rgic
otic66624823ot___ic
otitic83112683ot_itic
oxalis1339223oxal_is
ozalid1696683ozal_id
pelagic1237863pelagic
phallic1447293phallic
potamic13310853pota_mic
potassic1244923potassic
psalmic1345333psalmic
salic73424713_sal_ic
scaldic1235943scaldic
sialic8313633sial_ic
skaldic1443553skaldic
staggie9138463staggie
stannic936663stannic
static83118683sta_tic
stelic8313083stel_ic
tactic10612753_tactic
talc66226813_tal__c
tali46837163_tal_i_
talkie103914443_talkie
tallis63319963_tallis
tallit63422733_tallit
tannic82811473_tannic
telic76019823_tel_ic
thallic1246553thallic
toluic837693_toluic
tragic93811553_tragic
vocalic1446943vocal_ic

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 Filter1786911340270.390458182.1
2DLD Change Limit134027686.87319500.5
3Display Results68680.0332060.6
 (SQL Overall)178691687.29624491.6
 
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.