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

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
outsight124691(None) 
outfight1546101outfight
outright1248741outright
outsights1344181outsights
outfights1643782outfights
outsit63620892outsi__t
unsight1137482_unsight
bombsight1952093bombsight
catfight1744273catfight
eyesight1543523eyesight
footlight16255273footlight
foresight1645323foresight
fortnight1643803fortnight
gastight1365213gastight
gunfight1643493gunfight
gutsiest92610583gutsiest
insight1137913_insight
nutsiest82710243nutsiest
oiltight1244543oiltight
ought95221543ou___ght
outbought1544013outbought
outcaught1543333outcaught
outfish132210573outfish_
outfit93014953outfi__t
outfought1643763outfought
outhit92818473outhi__t
outrig72812853outrig__
outrightly1751923outrightly
outrigs82811263outrig_s
outsat62920283outs__at
outsert72819513outs_ert
outset64027453outs__et
outshoot1149163outshoot
outshot10312103outs_hot
outshout1149493outshout
outside82414193outsi_de
outsider9269643outsider
outsides92513233outsides
outsin63617563outsi__n
outsing83320463outsi_ng
outsings93410333outsings
outsins73417863outsi_ns
outsits73215253outsi_ts
outsize162411753outsi_ze
outsized18209743outsized
outsizes172311083outsizes
outskirt1246643outskirt
outslept1047703outslept
outsmart10168923outsmart
outsmelt10138163outsmelt
outspelt10148403outspelt
outspent101310213outspent
outstart81611283outstart
outstunt847223outstunt
outswept1346383outswept
outweigh1544503outweigh_
outweighs1642893outweighs
outwish13289853outwish_
outwit93014593outwi__t
outwith13279133outwith_
oversight1647633oversight
resight11510643_resight
sight94629293___sight
sunlight1245963sunlight
tight93626503__t_ight
unsights1244623_unsights
uplight13167363_uplight
upright13178293_upright
uptight13176033_uptight

Search took 8 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.453394461.4
2DLD Change Limit146162697.44019645.4
3Display Results69690.0302300.0
 (SQL Overall)178691697.92322553.5
 
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.