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 “oedipal” 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
oedipal104517(None) 
medial93819862medi_al
medical12312512medical
oedipally1543902oedipally
oedipean1142342oedipean
ordinal838632ordinal
pedipalp1242512pedipalp
redial74923112redi_al
aecial84817313aeci_al
aerial64625713aeri_al
audial7312993audi_al
bedpan1137583bed_pan
cedilla1036343cedilla
cordial10312943cordi_al
decimal1238083decimal
dedal75719023ded__al
denial74720513deni_al
devisal1136913devisal
dial55935063__di_al
edictal1046993_edictal
epical10413393_epical
espial839543_espial
fecial114714623feci_al
federal1148533federal
ferial94621253feri_al
fetial95716193feti_al
geminal10109903geminal
genial74917613geni_al
genipap1243123genipap
genital849793genital
geoidal936713geoidal
helical12311153helical
helipad1344723helipad
keypal1534893ke_ypal
khedival1941993khedival
lexical1637363lexical
medal86221333med__al
media84721713medi_a_
mediad104313713medi_ad
mediae94217413medi_ae
medials103914733medi_als
median94117543medi_an
medias93620783medi_as
medicals1349363medicals
medieval1443943medieval
medigap1374623medigap
medina94114093medina_
medinas103411463medinas
medivac1554693medivac
medusal1035183medusal
menial84223033meni_al
mesial84818083mesi_al
metical11315363metical
nadiral836343nadiral
nodical1049863nodical
oedema936573oedema_
oedemas1056693oedemas
ogival1035873o_gival
oidia6314953oidi_a_
opal66923523o___pal
optical1149863optical
optimal1145783optimal
orbital936923orbital
ordeal779253ord_eal
ordinals946753ordinals
ovoidal1144023ovoidal
pedal86022503ped__al
pedicab1446693pedicab
pedicel1237813pedicel
pedipalps1342133pedipalps
pedocal1237893pedocal
penial84120893peni_al
pipal95118353__pipal
poetical12311533poetical
predial103815413predi_al
radial74020393radi_al
radical103312793radical
recital9412163recital
redia65524483redi_a_
rediae74221993redi_ae
redials84416883redi_als
redias74523603redi_as
redip87816963redip__
redips93713843redip_s
redipt94116743redip_t
reginal84814293reginal
retial64724993reti_al
retinal75318353retinal
revisal1038263revisal
revival1337033revival
seminal91213403seminal
sepal77723003se__pal
serial64625863seri_al
telial65815363teli_al
tepal76319583te__pal
uredial82910483uredi_al
veinal93812963ve_inal
venial94218283veni_al
vesical12159813vesical
xenial133414903xeni_al

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.423422437.4
2DLD Change Limit1340271006.67020094.0
3Display Results1001000.0333030.3
 (SQL Overall)1786911007.12625075.9
 
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.