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

66 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
return623222521retu_rn
retorn610923422ret_orn
returns79712592returns
bethorn1238643bethorn
brethren1343783brethren
fenuron1075153fenuron
inturn63411563intu_rn
neuron6310373ne_uron
neutron737763neutron
readorn8310463readorn
reborn810016953re_born
rebury11349213rebu_ry
recarry1245063recarry
recur74116843recu_r_
recurred1137093recurred
recurrent1146713recurrent
recurring1237953recurring
recurs83315803recu_rs
recurve1237403recurve
reearn6612143re_earn
relearn747973relearn
remarry1235193remarry
repugn946493repu_gn
requin15310713requ_in
require16148653require
reran57329103re__ran
rerun58722153re__run
resurge839073resurge
retain64523283ret_ain
retaken113911803retaken
retard75018933ret_ard
retards85015003retards
retear63115483retear_
retears72814923retears
retiary1038333retiary
retirant8313593retirant
retire64927013ret_ire
retired84620143retired
retiree75019083retiree
retirer74715013retirer
retirers84311533retirers
retires74726213retires
retiring92717413retiring
retore67630763ret_ore
retort66831143ret_ort
retorts76016513retorts
retrain7615423retrain
retral64419743ret_ral
retrim83514873ret_rim
retro55020953ret__ro
retros63820193ret_ros
retry84718083ret__ry
retune69121953retu_ne
retuned86613973retuned
retunes76918403retunes
retuning9311583retuning
returned9459133returned
returnee8449883returnee
returner8397983returner
returners9376553returners
returning1038133returning
retuse66617223retu_se
reworn98122193re_worn
turn46330383__tu_rn
upturn8286243uptu_rn
veteran1039343veteran

Search took 10 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.1561145455.1
2DLD Change Limit134027669.39314268.8
3Display Results66660.0461434.8
 (SQL Overall)178691669.59518623.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.