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

61 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
offside145369(None) 
offsides1543391offsides
office1435692off_ice
offline1345782offline
onside7511802o_nside
outside82414192outside
affaire1344463affaire
affine12310503aff_ine
aside65122083__aside
bedside1156843bedside
beside95114613_beside
confide13310203conf_ide
dayside1236173dayside
depside1138403depside
dockside16154743dockside
downside1345293downside
effusive1743263effusive
farside1138603farside
foreside12310303foreside
fusile94313493_fusile
inside7613453_inside
offed12359163off_ed_
offence1545353offence
offend13365663offend_
offended1643653offended
offender1543723offender
offends14234293offends
offense1343683offense
offensive1842773offensive
offered1436143offered
officer1534213off_icer
offices1536243off_ices
offing13368643off_ing
offish15137273off_ish
offs107117013offs___
offset1238373offs_et
offsets1333503offsets
offshore1742543offshore
offstage1541903offstage
oreide7311673o_reide
oroide7311703o_roide
outride82615683outride
outsider9269643outsider
outsides92513233outsides
outsize162411753outsize
overside122013933overside
ovicide1346433ovicide
oxide131210953o__xide
ozonide1754963ozonide
poolside1145043poolside
portside1138163portside
preside10715613preside
reside74224933_reside
roadside1044893roadside
seaside839693seaside
side55444493___side
subside10410453subside
surfside1244853surfside
topside1037733topside
upside9289803_upside
wayside1435183wayside

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.423422437.4
2DLD Change Limit134027616.48320673.6
3Display Results61610.0302033.3
 (SQL Overall)178691616.93625762.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.