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

45 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
huswife164222(None) 
huswifes1742721huswifes
housewife18113732housewife
huswives1742932huswives
alewife1344923alewife
auspice1136523auspice
fishwife2042293fishwife
fusile94313493fus_ile
gussie72910153gussi_e
haywire1644743haywire
hessite1038993hessite
hospice14117063hospice
hostile10312553hostile
housewifey22122353housewifey
hunkie133812383hunki_e
hushing144514473hushing
huskier14369763huskier
huskies143212083huskies
huskily17236333huskily
husking154312053husking
husklike1433613husklike
hussies103213293hussies
hustle93113993hus_tle
hutlike14349063hutlike
jussive1734293jussive
justice1637423justice
justify2034663justify
midwife16225523midwife
muskie123412543muski_e
muspike1536043muspike
oldwife1492253oldwife
outwile10310263outwile
puslike1347563puslike
rusine63916593rus_ine
russify1334063russify
sunwise1036433sunwise
suspire937803suspire
swift116818053__swift
swine85625303__swine
swipe105217083__swipe
swive115316193__swive
tushie939723tushi_e
tussive1035303tussive
unwise9510803_unwise
wife105228023___wife

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.1401276364.3
2DLD Change Limit134027456.81319672.2
3Display Results45450.0162812.5
 (SQL Overall)178691456.96925640.8
 
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.