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

87 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
wifey14491367(None) 
wife105228021wife_
wifed125117741wifed
wifely15429421wifely
wifes114522561wifes
wifeys15425871wifeys
wifty144212091wifty
winey115325431winey
biffy164711132biffy
dicey114819332dicey
dikey135116422dikey
fey95940882__fey
fife106027702fife_
fifed125115972fifed
fifer115519972fifer
fifes114822392fifes
fifty145211422fifty
iffy135312282_iffy
jiffy21458312jiffy
jivey185111872jivey
life75433732life_
lifer85822152lifer
limey104721042limey
liney87029632liney
miffy163910202miffy
nifty115211632nifty
piney105727502piney
rife74632322rife_
rifely123710032rifely
rifer84721982rifer
riley84420582riley
wafer114417642wafer
wafery15398692wafery
waifed134011032waifed
waney115120322waney
wavey145115542wavey
whey135018712w_hey
whiney155012642whiney
whitey154911882whitey
widdy136112182widdy
wide85235412wide_
widely133311032widely
widen94717972widen
wider94826352wider
wides94832822wides
wiggy134510732wiggy
wile75944372wile_
wiled95231552wiled
wiles85437872wiles
willy115321912willy
wily106428812wi_ly
wimpy155911922wimpy
wincey144110382wincey
windy126118102windy
wine74953422wine_
wined94434182wined
winery125014282winery
wines85546862wines
wingy126521032wingy
winy107034322wi_ny
wipe94830282wipe_
wiped114722082wiped
wiper105421292wiper
wipes104827082wipes
wire75839812wire_
wired95327642wired
wirer85124952wirer
wires86034912wires
wiry106422832wi_ry
wise75737342wise_
wised95123342wised
wisely122711712wisely
wiser85522802wiser
wises85633192wises
wispy137210972wispy
wite75443272wite_
wited94727142wited
wites85536962wites
withy144813762withy
witney12356842witney
witty114717012witty
wive105931752wive_
wived125121502wived
wiver115924512wiver
wives115328922wives
wizen175813862wizen
wizes174723342wizes

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800871.46636698.5
3Display Results87870.0332636.4
 (SQL Overall)178691871.81298615.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.