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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
bongos9531665(None) 
bingos95514791bingos
bongo85720941bongo_
bongoes104314111bongoes
bongs87828421bong_s
congos94219881congos
mongos94318621mongos
bancos104713892bancos
bangs85627782bang_s
banjos15378892banjos
bentos86218302bentos
bigos85020012b_igos
binges93923122binges
bingo86020092bingo_
bingoes104013982bingoes
boffos14568192boffos
bogs75742752bo_g_s
bogus85616472bo_gus
bohos105618252bo_hos
boings96416872boing_s
bolos75531372bo_los
bonbon10310072bonbon
bonbons1139332bonbons
bonds86126842bon_ds
boners84825432boners
bones76446532bon_es
bong75633412bong__
bonged105719602bonged
bongoist1147642bongoist
bonitos939732bonitos
bonks116326462bon_ks
bonnes85621452bonnes
bonobos1136392bonobos
bonus75324322bon_us
bonzes175116102bonzes
boos67955032bo__os
boughs125414372boughs
boyos105418282bo_yos
bozos165216862bo_zos
broncos11188072broncos
buncos104011592buncos
bungs85323862bung_s
bunkos124210322bunkos
condos94322332condos
congas94417032congas
conges94928172conges
congo85623132congo_
congoes103617302congoes
congou94313242congou
congous103615082congous
contos84923232contos
dongas84914612dongas
dongs76525812dong_s
drongos935492drongos
gogos77516522go_gos
gongs74921612gong_s
hongs95126202hong_s
logos67225332lo_gos
longes75925572longes
longs65527062long_s
mangos94319342mangos
mondos95217332mondos
mongo810122412mongo_
mongoe94214982mongoe
mongoes103415712mongoes
mongol94912532mongol
mongols103310822mongols
monos75930862mon_os
mungos94311372mungos
nonegos837142nonegos
onos46229002_on_os
pengos94612412pengos
pingos95317672pingos
pongs85526342pong_s
rondos74616732rondos
songs67725552song_s
sorgos74514662sorgos
tangos74216322tangos
tondos75115922tondos
tongas74315532tongas
tongs65928472tong_s

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 Filter178691825510.736242786.7
2DLD Change Limit82551815.45315138.6
3Display Results81810.0461760.9
 (SQL Overall)178691816.23528659.3
 
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.