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

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
outdrank134543(None) 
outdrink1346551outdrink
outdrunk1343471outdrunk
outrank112611971out_rank
outdrag937002outdra_g
outdrags1046582outdrags
outdraw1136902outdra_w
outdrawn1245012outdrawn
outdraws1236232outdraws
outdrinks1443682outdrinks
outflank1544592outflank
outran63218892out_ran_
outrang83813952out_rang
outranks12298822out_ranks
outthank1544352outthank
cutbank1545533cut_bank
drank104816203___drank
ourang73311063ou__rang
outask1039103out__ask
outback15310653out_back
outbark1339453out_bark
outbrag1036993outbra_g
outbrags1136693outbrags
outbrave1357133outbrave
outbrawl1344823outbrawl
outbreak1444773outbreak
outcrawl1344583outcrawl
outdance11238733outd_ance
outdare83113403outd_are
outdared102711513outdared
outdares92712463outdares
outdaring1179723outdaring
outdate83016423outd_ate
outdoing1039423outdoing
outdone8311643outd_one
outdrawing1546023outdrawing
outdream1144713outdream
outdreams1243553outdreams
outdreamt1244203outdreamt
outdress9137323outdress
outdrew1137143outdr_ew
outdrive1236893outdrive
outdrop1036193outdr_op
outdrops1136543outdrops
outdrove1236473outdrove
outearn7310683outearn_
outearns838403outearns
outflanks1643233outflanks
outgrin8810553outgrin_
outgrins979823outgrins
outland81212343out_land
outman83115033out_man_
outmans92413283out_mans
outplan9249443outplan_
outplans10259533outplans
outpray12268083outpra_y
outprays13236933outprays
outrace92418553out_race
outrage82616893out_rage
outrance102212783out_rance
outrange92410223out_range
outranked14247863out_ranked
outrate72323183out_rate
outrave102614413out_rave
outring84021023out_ring
outrock1339303out_rock
outrun63213303out_run_
outrung8349573out_rung
outruns72911543out_runs
outsang83411273out_sang
outspan938743outspan_
outspans1038223outspans
outsprang1243903outsprang
outstand938043outstand
outtalk1138233out_talk
outtask1137053out_task
outthanks1653153outthanks
outthink1545583outthink
outtrade938343outtrade
outtrick1445573outtrick
outwalk1437623out_walk
overdrank1745123overdrank
overrank1548113overrank
quadrans1866363quadrans
quadrant1858083quadrant
trank96222423__t_rank
undrunk1254473_undrunk

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 Limit146162876.72021750.3
3Display Results87870.0302900.0
 (SQL Overall)178691877.20324807.9
 
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.