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

70 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
deraigned124409(None) 
arraigned11103032arraigned
deigned1037502de__igned
deraign936572deraign__
deraigns1034882deraign_s
derailed102410402derai_led
deranged1137692derang_ed
designed1136942de_signed
detained103111642detai_ned
detrained1158912detrai_ned
drained93713252d_rai_ned
arraigner1092973arraigner
beringed1298173ber_inged
brained103816103_brai_ned
deaconed1237493de_aconed
deadened1137233de_adened
deafened1335853de_afened
deaired9411533de_ai_red
deaned84620453de_a__ned
debagged1433723deba_gged
declined123910883decli_ned
defanged1435433defang_ed
defined123813823de_fi_ned
defragged1643043defra_gged
delaine8314793delai_ne_
delaines9312963delai_nes
depainted1375843depainted
deraigning1344103deraigning
derange939813derang_e_
deranger1037353derang_er
deranges1039973derang_es
derated93623503dera__ted
deratted1048403dera_tted
derided102914253der_i_ded
deringer1038143der_inger
derived123912763der_i_ved
derringer1144593derringer
designee1087753de_signee
designer1036543de_signer
destained1158253destai_ned
destined103312453desti_ned
detailed10319873detai_led
detainee92511723detai_nee
detainer92910793detai_ner
deveined1336673devei_ned
dragged11379563d_ra_gged
draggled1254673d_raggled
dragnet91211433d_ra_gnet
drainer83012843d_rai_ner
eloigned1043423_eloigned
ermined10410603_ermi_ned
feigned1245353fe__igned
grained93814273_grai_ned
pertained1238503pertai_ned
rained75024603__rai_ned
realigned1145333realigned
refrained1347223refrai_ned
regained102111243regai_ned
reigned949213__reigned
remained112412893remai_ned
reraised9312363rerai_sed
rerigged1136243rer_igged
resigned1038863re_signed
retained93016093retai_ned
retrained10411313retrai_ned
scraighed1643593scraighed
sprained1138433sprai_ned
strained9412253strai_ned
trained84117203_trai_ned
undersigned14114973undersigned

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 Filter1786911486410.423422437.4
2DLD Change Limit148641706.65622331.9
3Display Results70700.0302333.3
 (SQL Overall)178691707.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.