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

85 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
bipolar114546(None) 
dipolar1056851dipolar
ambipolar1552012ambipolar
bicolor1145612bicolor
bifilar1244042bifilar
bolar75123472b__olar
polar75623452__polar
unipolar1043422unipolar
antipolar11106943antipolar
areolar779223areolar
basilar937313basilar
bezoar1736913bezo_ar
bicolors1256163bicolors
bicolour1243693bicolour
bifocal1445373bifocal
bifold1237223bifol_d
biller84923483bi_ller
bilobular1392423bilobular
bilocular1363693bilocular
bimodal1245663bimodal
binocular1394613binocular
biogas94310913bi_ogas
bioplasm1444873bioplasm
biota74516823bi_ota_
biotas84313923bi_otas
biovular1343613biovular
bipedal1245683bipedal
biplane1139033bip_lane
bipod104410823bipo__d
bipods11408593bipo_ds
bipolarity1753033bipolarity
bipolarize2353743bipolarize
birler85715083bi_rler
bivouac1442573bivouac
bizonal1845563bizonal
boar66134293b__o_ar
bola66035563b__ola_
bolas74733763b__olas
boyar106013763b__oyar
burglar1065533burglar
byplay1634193byp_lay
cipolin1148783cipolin
citola838393citola_
citolas939363citolas
copular113810613copular
cupola10317693cupola_
cupolas11277753cupolas
cupular11317633cupular
dipole91112853dipol_e
dipoles101013753dipoles
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 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 Filter1786911340270.420425454.8
2DLD Change Limit134027856.25321434.0
3Display Results85850.0302833.3
 (SQL Overall)178691856.70326658.4
 
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.