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

62 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
bespouse124510(None) 
bespoused1443751bespoused
bespouses1345141bespouses
espouse936401_espouse
bespoke15468112bespo_ke
espoused1134852_espoused
espouser1044382_espouser
espouses1037302_espouses
response1037742response
spouse84112512__spouse
baghouse1445213baghouse
beadhouse1544423beadhouse
because1136233be_cause
bedehouse1544073bedehouse
bedpost1247243bedpo_st
bemuse1038943be__muse
berceuse1243433berceuse
bescour1145203bescou_r
bescoured1444333bescoured
bescours1245093bescours
beshout12311833beshou_t
beshouted1544073beshouted
beshouts1346763beshouts
besmoke15416623besmo_ke
besmokes16406363besmokes
besnows1245153besnows_
besoms105712733bes_oms_
besoothe1343783besoothe
besots86415453bes_ots_
bespake15436963besp_ake
bespoken16505013bespoken
bespousing1553403bespousing
bestows1248863bestows_
blouse84714723b__louse
bouse75931853b___ouse
bughouse1445073bughouse
delouse839833de_louse
depose94215763de_po_se
despise1038683desp_ise
despots10319683despots_
dispose10312763dispo_se
espousal1083003_espousal
espousers1143383_espousers
expose1549523_expo_se
gashouse1245693gashouse
henhouse1445573henhouse
mesopause1352703mesopause
mispoise1248263mispoise
pesthouse1445963pesthouse
rearouse839363rearouse
rehouse10311773re_house
repose84121413re_po_se
repousse1046053re_pousse
respoke134311283respo_ke
responsa1043583responsa
responses1147443responses
respots92912763respots_
scouse84113633__scouse
souse56530773__s_ouse
spoused10349653__spoused
spouses92912813__spouses
teahouse1146073teahouse

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.1561145455.1
2DLD Change Limit146162627.82618676.5
3Display Results62620.0163875.0
 (SQL Overall)178691627.99822342.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.