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 “boursins” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

159 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
boursins103751(None) 
boursin938281boursin_
boudins10311312bou_dins
bourbons1245342bourbons
bourdons1136432bourdons
bourns84114062bour__ns
bourses94014302bours_es
bousing103718042bou_sing
burins84221892b_ur_ins
coursing113112022coursing
coursings12235872coursings
cousins9516002cou_sins
outsins73417862_outsins
basins85722763b__asins
bearskins1543373bearskins
becursing1435453becursing
berlins93216013b_erlins
blousing1138793blou_sing
blousons1054403blou_sons
bluefins1345113bluefins
blurbing13326503blurbing
blurring11277233blurring
blurting11258773blurting
boarding123110233boarding
boardings13296063boardings
bobbins103410343bo_bbins
bodkins1438313bo_dkins
boffins15329073bo_ffins
bolsons969483bo_lsons
bombesins1543783bombesins
boomkins1645503boomkins
boreens9310403bo_reens
boring94724873bo_r_ing
borings103614243bo_r_ings
borking144716173bo_rking
borons85520543bo_r_ons
borshts1266543bo_rshts
bosons85016653bo__sons
bossies94116833bo_ssies
bossing103714603bo_ssing
bosuns8439383bo__suns
botulins1047063botulins
boudin9412373bou_din_
boudoirs1143703boudoirs
bougies103715183bou_gies
bouncing13318773bouncing
bounding123012133bounding
bounties10311403bounties
bourbon1135813bourbon_
bourdon1036423bourdon_
bourgeons1244393bourgeons
bourgs9459993bour__gs
bourn75518483bour__n_
bourne83714093bour__ne
bournes93615023bour_nes
bourrees10127643bourrees
bourride1144403bourride
bourrides1244823bourrides
bourse84414333bours__e
bouses84931783bou_s_es
boutons9310783bou_tons
bowfins15267703bo_wfins
bowsing134012503bo_wsing
brains85125473b__rains
brins75533973b__r_ins
brucins1158003bru_cins
bruins86014953b__ruins
bruising11279143bruising
bumkins15318013b_umkins
burans85019303b_ur_ans
burdens1039713b_urdens
burdies104117563b_urdies
buries84633273b_ur_ies
burin75626063b_ur_in_
burking143716323b_urking
burling104421133b_urling
burnies94017823b_urnies
burning104215503b_urning
burnings11387623b_urnings
burns74926783b_ur__ns
burping124012943b_urping
burring104016993b_urring
bursars94510893b_ursars
bursas85318273b_urs_as
burses84425513b_urs_es
bursitis1045033b_ursitis
bursting1138703b_ursting
bursts85116243b_urs_ts
burtons9310853b_urtons
burying133413913b_urying
busies85525263b_u_sies
busing96420593b_u_sing
busings103711223b_u_sings
buskins133310943b_uskins
bussing103614623b_ussing
bussings11386663b_ussings
coarsens10348123coarsens
cortins92421333co_rtins
courlans10117613courlans
coursers104412303coursers
courses94218893cours_es
courting112514573courting
cousin8517163cou_sin_
cursing104217033_cursing
dormins10311273do_rmins
dourine8311453dour_ine
dourines9311373dour_ines
dousing93315763dou_sing
eosins64419163eo__sins
fourgons1234833fourgons
hoarsens11306023hoarsens
horsing113215583ho_rsing
houris94514583hour_i_s
hourlies1138343hourlies
housing113316523hou_sing
housings12307483hou_sings
louring83916503lour_ing
lousing83817733lou_sing
moulins9312703mou_lins
mourning1156793mourning
mournings1243533mournings
mourns84111013mour__ns
mousing103816273mou_sing
mousings11277703mou_sings
moussing1138143moussing
mureins9310733_mureins
nursing84012553_nursing
nursings9325773_nursings
opsins8411713_o_psins
orcins83313433_o_rcins
orpins83614163_o_rpins
outsin63617563_outsin_
outsing83320463_outsing
outsings93410333_outsings
outsits73215253_outsits
pocosins1258953pocosins
pouring103115863pour_ing
poussies1038113poussies
purins83722653_pur_ins
purlins93415423_purlins
pursing103715553_pursing
rosins64521863ro__sins
rousing83920553rou_sing
sourcing1158353sourcing
sourdine936893sourdine
sourdines1046743sourdines
souring83219063sour_ing
soursops1043213soursops
sousing83517823sou_sing
tocsins939963to_csins
torsions839183to_rsions
touring82915193tour_ing
tourings9277373tour_ings
tourisms1037613tourisms
tourists838313tourists
tousing82916993tou_sing
ursids737823__ursids
ursine64114123__ursine
worsens104610263wo_rsens

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 Filter1786911461620.450397091.1
2DLD Change Limit1461621597.78318779.6
3Display Results1591590.0463456.5
 (SQL Overall)1786911598.27921583.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.