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

91 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
dipolar105685(None) 
bipolar1145461bipolar
dipole91112852dipol_e
dipoles101013752dipoles
polar75623452__polar
unipolar1043422unipolar
ambipolar1552013ambipolar
antipolar11106943antipolar
areolar779223areolar
bicolor1145613bicolor
bifilar1244043bifilar
bolar75123473__bolar
cipolin1148783cipolin
citola838393citola_
citolas939363citolas
copular113810613copular
cupola10317693cupola_
cupolas11277753cupolas
cupular11317633cupular
decolor1087033decolor
deodar837713d_eodar
deposal1037153deposal
deposer104011843deposer
dialer74315433di_aler
dialler848813dialler
dibbler124510283dibbler
diddler103511513diddler
dinar66319893di__nar
dinosaur942953dinosaur
diol57329143di_ol__
diols65521013di_ol_s
diopter1038473diopter
dioxan1465773di_oxan
diplex16408053dip_lex
diploe9810153dip_loe
diploes101111493diploes
diploic1247763diploic
diploid11310293diploid
diploma1295933diploma
diplomas1385993diplomas
diplomat1387433diplomat
diplont10311693diplont
dipnoan1044653dipnoan
dipodic1397593dipodic
dipody1336363dipo_dy
dipper114017793dip_per
dippier123111393dippier
dipsas9359893dip_sas
diptera1037213diptera
disbar938513di_sbar
discolor1146423discolor
display1336663display
disposal1147023disposal
disposer11310413disposer
dollar74110983d_ollar
dolor67617963d__olor
eidola737683eidola_
escolar946053escolar
fibular12267983fibular
filar84819293fi__lar
hilar85418143hi__lar
isobar836143_isobar
kilobar1344613kilobar
ligular8348533ligular
lipoma1046753lipoma_
lipomas1156443lipomas
molar75223093__molar
nonpolar1046283nonpolar
osmolar944483osmolar
papular11299773papular
pilar75221503__pilar
pillar8314023pi_llar
pilular938203pilular
polars84419353__polars
poler74431793__poler
poplar103611113__poplar
popular11319573popular
pupilar11125323pupilar
rippler113210103rippler
scholar1236963scholar
similar937853similar
simular938683simular
solar55927343__solar
stipular1045853stipular
subpolar1245193subpolar
tippler11348343tippler
titular737523titular
tolar55524113__tolar
viola85915543vi_ola_
violas93713523vi_olas
volar86917413__volar

Search took 9 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 Limit134027918.36016031.9
3Display Results91910.0303033.3
 (SQL Overall)178691918.81320275.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.