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

69 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
blurts8441264(None) 
bluets87215491bluets
blunts84512891blunts
blurbs10489311blurbs
blurs74619081blur_s
blurt77625621blurt_
alerts64418222alerts
bhuts105812952bhu_ts
blares85021632blares
blasts85116772blasts
blats75132502bl_ats
bleats85518612bleats
blets75324942bl_ets
bloats85215762bloats
blots75626172bl_ots
blubs95818152blu_bs
blues75127042blu_es
bluest84016482bluest
bluet75631192bluet_
blueys11419522blueys
bluffs14388372bluffs
blumes105917792blumes
blunt75525022blunt_
blur66020532blur__
blurb95214902blur_b
blurry11437672blurry
blurted10399782blurted
blurter9419832blurter
blurters10348372blurters
boarts84716872boarts
borts76735452b_orts
bourgs9459992bourgs
bourns84114062bourns
bouts75131312bou_ts
bruits85714452bruits
brunts85215452brunts
bruts75922952bru_ts
bunts75729802b_unts
buras74736302b_uras
burbs95423492b_urbs
burds84626062b_urds
burets84321262b_urets
burgs84924092b_urgs
burls74228852b_urls
burns74926772b_urns
burps94220172b_urps
burrs74925652b_urrs
burs65847422b_ur_s
burst75332242b_urst
bursts85116242b_ursts
busts75227692b_usts
buts67247692b_u_ts
butts75824252b_utts
courts84216172courts
flirts95411482flirts
fluyts12367152fluyts
gluts66120132glu_ts
hurts86922822_hurts
lunts55826902_lunts
lures56138532_lures
lurks95218742_lurks
lusts55022802_lusts
slurbs8439742slurbs
slurps84410002slurps
slurs54123372slur_s
sluts54523982slu_ts
spurts84814972spurts
sturts63915142sturts
yurts87216532_yurts

Search took 3 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.343520965.0
2DLD Change Limit82551692.47033421.5
3Display Results69690.0164312.5
 (SQL Overall)178691692.82963164.0
 
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.